Re: Indexes not used

Ashish,

      Yes, the second instance is taking more time and that is why I want to make it use the already existing valid indexes.

-A

"Ashish Mittal" <mittalashish_at_yahoo.com> wrote in message news:<z5qh8.22371$e07.4587_at_sccrnsc01>...
> 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 Thu Mar 07 2002 - 16:01:08 CST