Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Different user, different indexes used. Why?

Re: Different user, different indexes used. Why?

From: bdbafh <bdbafh_at_gmail.com>
Date: 16 Feb 2007 06:22:42 -0800
Message-ID: <1171635762.029658.159590@v45g2000cwv.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US