Re: Getting ORA-01502 even with SKIP_UNUSABLE_INDEXES = TRUE

<vafanassiev_at_aapt.com.au> wrote in message news:1102383431.666689.218880_at_f14g2000cwb.googlegroups.com...
>
> >
> > 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.
>

not sure where this is going. The Bug search results in similar cases (of which one bug I mentioned above). Based on that, your case seems like a bug too ... which you say looks to be fixed in 10G.

Asking oracle supprt directly might be a better choice .. don't you think?

Anurag Received on Mon Dec 06 2004 - 23:49:56 CST