Re: Two different explain plans for same query

Please post the plans and the queries used to generate them ...

with 9r2 try after the explain

select * from table(dbms_xplan.display) ; "Francois" <f_de_wet_at_hotmail.com> wrote in message news:6633def8.0304222334.831955_at_posting.google.com...
> We are running Oracle 9r2 on a Win2k box . We have a very simple setup
> with one instance and two different schemas ; "Live" and "Test" . We
> refresh the "test" from time to time by doing an import of the
> "live"export . We are finding that a simple sql query is starting to
> take much longer in the live for exactly the same operation in the
> test (up to ten times) . We have a table pallets which has about
> 1500000 records in it and when you do a select for the whole table
> with an order by the primary key , the live environment does not use
> the index of the primary key but does a full scan whereas the test
> uses the index and it is much faster . We have compared the explain
> plans and this is the only difference . If you could shed some light
> on this , I would be very happy
Received on Wed Apr 23 2003 - 05:24:23 CDT