RE: VLDBA's: gather stats on a large table

Thanks Christian,

That means my understanding was good.

>> Does the application take advantage of partition 
>> pruning? If yes, even if the SQL are not 
>> referencing the partitions directly, it's 
>> important to have partition-level stats.
Just your last sentence in your original response was
a little bit confusing and I wanted to check is
anything changed from what I know.

This is then telling that partition level statistics
are not of any use for the original question????

Also not of so much use when using PL/SQL and static
SQL with binds on the partitioning key columns.

Regards,
Zoran



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
--
http://www.freelists.org/webpage/oracle-l

Other related posts: