Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Indexes not used
hi,
I have a ora db migrated from 8.0.5 to 8.1.6.1.
Have schemas created by a third party application.
In one instance, tkprof/explain plan output shows that indexes for
tables being used. Nested loops used.
In a different oracle instance (schema created by same third party
software), the indexes are not being used. Full table scans are
happening. Hash joins are used.
Is it possible to make the second instance use the indexes for the same sql query ?
Thanks,
-A
Received on Tue Mar 05 2002 - 11:29:01 CST