Re: Index not being used
- From: Martin Klier <usn@xxxxxxxxx>
- To: ksmadduri@xxxxxxxxx
- Date: Tue, 20 Apr 2010 13:03:27 +0200
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:
