Sometimes, even when you use a hint, it may be performing a full table scan. I guess, if you use the RULE hint, then it is forced to use the index. In your case, the performance may increase.
|
Results 1 to 10 of 28
Thread: Oracle didn't use indexThreaded View
|
Click Here to Expand Forum to Full Width |