Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Indexes not used

Indexes not used

From: Anamika <hemanir_at_yahoo.com>
Date: 5 Mar 2002 09:29:01 -0800
Message-ID: <5130f039.0203050929.f10bc82@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US