Why do you want to use the index instead of the hash join? Is the query
taking more time?
"Anamika" <hemanir_at_yahoo.com> wrote in message
news:5130f039.0203050929.f10bc82_at_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 Wed Mar 06 2002 - 08:55:27 CST
