Re: V6.0.33 bug on indexed retrievals??

Carlos_at_rustle.demon.co.uk writes in article <765734249snz_at_rustle.demon.co.uk>:
>
> Has anyone out there come across this "feature" under ORACLE V6.0.33 ??
>
> Symptom: Indexed queries of a large table suddenly take 10 times as
> long as usual.
>
>
> Conclusion: The index appears to become unusable, but the Dictionary
> and the VALIDATE INDEX options are unable to recognise
> this. The fact that dropping/recreating the index does not
> clear the problem is confusing.
>
> This is not a common problem, (it has ocurred twice in 18 months), but the
> ORACLE Help desk assures me they have not had any other occurrences reported
> to them before (or since?)
>
> - Has anyone got any ideas????
>

Did you try to perform your query _without_ the index ? If you talk about a _large_ table, then I suspect the query-times will not only grow up to a factor of 10.....

Maybe there were massive deletes or inserts on the table, and therefore the index-entries was heavily split.

Willy Klotz

Willys Mail     FidoNet   2:2474/117  2:2474/118     Mail Only System
                CIS: 100020,3517       USR Courier HST dual standard
                willyk_at_kbigate.stgt.sub.org
                ->   No Request from 06.00 to 08.00 <-
======================================================================