Re: performance question

Many thanks to Wolfgang B. who pointed out the problem to this.
The problem was that one database has histogram data and the other doesn't. I have verified it. 

Thanks to all who replied.

Joan

Stefano Cislaghi wrote:


That's interesting.
May you run

select column_name, num_distinct, density, histogram, num_buckets
from user_tab_col_statistics
where table_name = 'YOUR_TABLE'

and check stats.


Stefano



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

Other related posts: