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 ?