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