Re: Different user, different indexes used. Why?

> 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.
>
> - Bobby

I've confirmed that neither of these situations is the case. They are selecting from the same data and returning the same data. I'm now investigating v$sql_plan, traces, and the prospect of VPDs. Any other ideas?

Thanks,
Sam Received on Wed Feb 14 2007 - 16:53:11 CST