Re: Index not being used

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 |

--
http://www.freelists.org/webpage/oracle-l