Re: Getting ORA-01502 even with SKIP_UNUSABLE_INDEXES = TRUE

>
> Well ... it was a bug in earlier versions. Try logging into metalink
and search for Bug 2396261
>
> Anurag

Anurag,

Thanks for the reference. However:
1. In the example given in Bug 2396261 they use two indexes, both UNIQUE
and both used to enforce constraints. I use NON-UNIQUE index that is not used
for any constraint.
2. The workaround they are suggesting isn't perfect. What's the point of having indexes if you are not going to use them ***at any time***? The whole idea of this ALTER SESSION SET SKIP_UNUSABLE_INDEXES = TRUE is that you should be able to use index when it is available. Clearly if indexes are unavailable most of the time then you simply drop them, but if indexes are available 95% of the time? 3. Finally, the status of the bug says "Not Feasible to fix". Still, they fixed in 10g. Received on Mon Dec 06 2004 - 19:37:11 CST