Re: performance question

  • From: Joan Hsieh <joan.hsieh@xxxxxxxxx>
  • To: s.cislaghi@xxxxxxxxx
  • Date: Wed, 14 Apr 2010 09:24:14 -0400

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



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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2010