Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Different user, different indexes used. Why?
>
> Well you've got a version of Oracle not supported during the current
> millenium (and we don't know what 8i means ... 8.1.5? 8.1.7.0? 8.1.7.4?)
> so it is rather hard to offer too much help. I'd suggest posting the
> SQL statements and explain plans copied directly from SQL*Plus as they
> executed.
>
> Also include the following from each:
>
> SELECT dbid, name FROM v$database;
>
> SELECT instance_name, host FROM v$instance;
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Oracle 8.1.7.4.0.
I'm not allowed to post any detail of the query or explain plan.
I believe I've isolated the problem to table policies that may be modifying the query predicates. I'm still working on it though.
Thanks,
Sam
Received on Thu Feb 15 2007 - 08:20:28 CST