Re: Different user, different indexes used. Why?

On Feb 15, 9:20 am, samuelroll..._at_gmail.com wrote:
> > 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- Hide quoted text -
>
> - Show quoted text -

And you cannot use an eitor to obfuscate names before posting here? vi thelogfile
:%s/mysupersecrettablename/TABLE_ONE/g
...

Guess you don't want the help that badly. Received on Thu Feb 15 2007 - 11:53:42 CST