DEVFYI - Developer Resource - FYI

How can you avoid indexes ?

ORACLE Interview Questions and Answers (Part 5)


(Continued from previous question...)

65.How can you avoid indexes ?

TO make index access path unavailable - Use FULL hint to optimizer for full table scan - Use INDEX or AND-EQUAL hint to optimizer to use one index or set to indexes instead of another. - Use an expression in the Where Clause of the SQL.

(Continued on next question...)

Other Interview Questions