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