How you will avoid your query from using indexes?
ORACLE Interview Questions and Answers (Part 4)
(Continued from previous question...)
592. How you will avoid your query from using indexes?
SELECT * FROM emp
Where emp_no+' '=12345;
i.e you have to concatenate the column name with space within codes in the where condition.
SELECT /*+ FULL(a) */ ename, emp_no from emp
i.e using HINTS
(Continued on next question...)
Other Interview Questions