Re: Index not being used
- From: Alisher Yuldashev <yuldashev@xxxxxxxxxxx>
- To: ksmadduri@xxxxxxxxx
- Date: Tue, 20 Apr 2010 14:14:35 -0400
Kumar,
If you look at the cardinality, you will see the root cause of the cost
difference.
The query on Database1 calculates the cardinality as 47861, whereas the
query on Database2 calculates the cardinality as 13.
Check if the data in the tables are same. Also, compare the statistics
and histograms if you have them.
Thanks,
Alisher Yuldashev
Senior Oracle DBA
www.pythian.com
Kumar Madduri wrote:
Database 1 is on 11.1.0.7.2
--------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 47861 |
12M| 679K ( 3)| 02:15:51 |
=====
Database 2 is on 11.1.0.7.1 and
--------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 13
| 3588 | 7 (0)| 00:00:01 |
--
//www.freelists.org/webpage/oracle-l
Other related posts:
