Home » RDBMS Server » Performance Tuning » Dynamic_sampling and partitioning (
Dynamic_sampling and partitioning [message #407701] Thu, 11 June 2009 02:53 Go to next message
Messages: 31
Registered: June 2009
Location: Paris

When the optimizer_dynamic_sampling is activated and when we execute a query on a partionned table without precising the partitioning criterion. Are statisctics collected dynamicly on all the table ?

And if I precise the partitionning criterion, are statistics collected only on the partition?

Moreover, how to know if it's better to collect the statistics for each partition or globally for all the table ?
Re: Dynamic_sampling and partitioning [message #407791 is a reply to message #407701] Thu, 11 June 2009 11:16 Go to previous message
Messages: 24971
Registered: January 2009
Location: SoCal
Senior Member
When all else fails Read The Fine Manual

Previous Topic: slow query with MERGE JOIN CARTESIAN and LATCH cache buffer chains
Next Topic: How to tune memory size in oracle 8i (merged)
Goto Forum:

Current Time: Thu Oct 27 18:19:13 CDT 2016

Total time taken to generate the page: 0.13523 seconds