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 - 02:34:19 CDT
