Re: performance question

  • From: Stefano Cislaghi <s.cislaghi@xxxxxxxxx>
  • To: joan.hsieh@xxxxxxxxx
  • Date: Wed, 14 Apr 2010 07:50:37 +0200

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.stefanocislaghi.eu

2010/4/13 Joan Hsieh <joan.hsieh@xxxxxxxxx>:
>
> Hi all,
>
> I got the 10053 trace file, the base statistical infor are same. However,
> the access ps_job table are different.
--
//www.freelists.org/webpage/oracle-l


Other related posts: