DEVFYI - Developer Resource - FYI

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
where emp_no=1234;
i.e using HINTS

(Continued on next question...)

Other Interview Questions