Hi,
I have a GTT table in which data is volatile in nature. Response time of queries always varies. so I decided to implement Dynamic sampling on GTT.
Concern: currently I am not allowed to make any changes in the program, like passing the hint or setting the dynamic sampling in the session level.
so if delete the existing stats and lock stats for said GTT, will it use dynamic sampling as per the DB level "OPTIMIZER_DYNAMIC_SAMPLING" when next time the query runs over this table ?
Thanks in advance