8i | 9i | 10g | 11g | 12c | Misc | PL/SQL | SQL | RAC | Linux

Home » Misc » Here

Comments

Statistics Collection Enhancements in Oracle Database 11g Release 1 - Provide the optimizer with additional selectivity information and avoid new statistics adversely affecting performance.



Sergiy said...

please change from OPTIMIZER_PENDING_STATISTICS to OPTIMIZER_USE_PENDING_STATISTICS

Tim... said...

Hi.

Corrected it. Thanks for the heads-up. :)

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!