I have enabled the DBS control Stats parameter for User data change set to 8%.. ObjectUsage is enabled in DBQL field.. Before setting any of these DBS Control Stats fields the defualt that system was considering to collect the stats was 21%.. Hence i decided to enable the stats field and set to a initial 8%.
There are situation when the optimiser estimates that the data change did not go beyond 8%..
My question is given the above scenario how can i force to collect the stats even if it did not meet the 8% data change criteria?
To force one time stats collection you can use ‘NO THRESHOLD FOR CURRENT’ option.
You will find more details in Carrie's blog