Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to get Oracle to an Index without hints?
set the init.ora paramter
optimizer_index_cost_adj from 100 to 10.
This will tell the CBO that index is less costly then full tablescans.
Received on Tue May 07 2002 - 19:36:54 CDT