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 two queres probably aren't accessing the same tables. Look for
unqualified table names in your query. You could have private
synonyms that differ for each user. Or one of the users could have a
table of the same name in their own schema.
Received on Wed Feb 14 2007 - 15:44:29 CST
