Re: performance question

From: Stefano Cislaghi <s.cislaghi_at_gmail.com>
Date: Wed, 14 Apr 2010 07:50:37 +0200
Message-ID: <t2ld06f0d321004132250pfa6570cbs13845482cb5bf5fe_at_mail.gmail.com>



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_at_tufts.edu>:

>
> Hi all,
>
> I got the 10053 trace file, the base statistical infor are same. However,
> the access ps_job table are different.
-- http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 14 2010 - 00:50:37 CDT

Original text of this message