Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is Dynamic sampling useful when table stats are up to date ?

VitaminDMay 12 2020 — edited May 12 2020

Versions 11.2 and higher

Question from a newbie:

As I understand, dynamic sampling ('Dynamic Statistics' from 12.1 and higher) is useful when optimizer stats are not available for a table.

So, is dynamic sampling useful when table stats are up to date for optimizer to use ? I mean, is there any other use case where you set OPTIMIZER_DYNAMIC_SAMPLING  to a higher value in a session ?

Comments
Post Details
Added on May 12 2020
3 comments
257 views