Forcing the Optimizer to Use an Index
You can force the optimizer to use an index by using several techniques. You can use an INDEX
hint (there are several of these, as explained later) to tell the optimizer to use a specific index or even any index the optimizer finds best. You can also adjust the initialization parameter optimizer_index_cost_adj,
which, by making a direct adjustment to the computed cost of the index access, makes it very likely to cause the database to use an index instead of doing a full table scan.
Note The effect of adjusting optimizer_index_cost_adj
parameter is not really to force an index use per se. Rather, it forces ...
Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.