InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Can You Avoid Indexes ? |
|
Answer» 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.. 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.. |
|