Re: Different user, different indexes used. Why?

On Feb 14, 1:45 pm, samuelroll..._at_gmail.com wrote:
> When I connect using SQL*Plus to Oracle 8i DB using cost based
> optimization and run _identical_ queries (syntax and literals) as two
> different users, as one of the users the query takes less than a
> second and as the other user it takes over a minute. I did an explain
> plan on both and found that for the fast user unique indexes are used
> on all three tables in the query and for the slow user only one unique
> index is used while the other two indexes are ignored.
>
> Can someone explain how this could happen?
>
> Thanks,
> Sam

the 10053 event is your friend.
http://www.centrexcc.com/What%20is%20new%20in%20the%20Oracle%209i%20CBO.pdf

-bdbafh Received on Fri Feb 16 2007 - 08:22:42 CST