Re: Index not being used
- From: Anupam Pandey <my.oralce@xxxxxxxxx>
- To: usn@xxxxxxxxx, ksmadduri@xxxxxxxxx
- Date: Tue, 20 Apr 2010 16:36:56 +0530
Hey Madduri ,
Is this that in both the databases you have same
db_file_multiblock_read_count and number of blocks consumed by that table .
Thanks
Anupam
On Tue, Apr 20, 2010 at 4:33 PM, Martin Klier <usn@xxxxxxxxx> wrote:
> Please allow a hint for you:
>
> http://www.usn-it.de/index.php/2010/03/08/oracle-how-to-create-a-good-execution-plan/
>
> Try to run the query, and see how the row numbers and costs are
> distributed. Explain plans are not reliable in all aspects.
>
> Regards
> Martin
>
>
> Kumar Madduri schrieb:
>
> > Before blaming it on PSU, I was thinking if there was anything else that
> > I can do
> > 1. Stats are most recent and representative on the involved
> > 2. Checked distinct_keys, clustering_factor, num_rows between both
> > databases and about the same.
> > 3. Checked this
> > http://jonathanlewis.wordpress.com/2007/02/15/index-not-used-10g/ and it
> > may be that I am hitting it b ut I am not able to validate it.
> > 4. If I hint the 11.1.0.7.2 database to use the index hint, then the
> > index gets used
> >
> > I am going to switch Oracle Homes and try but just want to make sure
> > that I there was anything else I could try
> >
> > Thank you
> > Kumar
> >
>
> --
> Usn's IT Blog for Linux, Oracle, Asterisk
> http://www.usn-it.de
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
