Re: Interview Index problem

what I understand, if your have short table then index is not in use (full table scan) but if you have large table then that index will be used which has less no. of records like if in table if we have 1000 entries where deptno=10 and 1500 entries where sal>1000 then deptno index will be in use.

Is it correct.............................