Oracle dynamic sampling hint

• dynamic_sampling hint is very useful for highly volatile tables and global temporary tables.
• In 10g, you can use the dynamic_sampling hint to direct Oracle to estimate the cardinality of highly volatile tables on the fly.
• The dynamic sampling hint is also useful for estimating the size of dynamically created objects such as global temporary tables (GTT's)
• select /*+ dynamic_sampling(temp_cpgrp 4) */ cpgrp_num, cpgrp_desc,