Statistics

Database
KN
Enthusiast

Statistics

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?

1 REPLY
Junior Supporter

Re: Statistics

To force one time stats collection you can use ‘NO THRESHOLD FOR CURRENT’ option.

 

You will find more details in Carrie's blog

https://developer.teradata.com/blog/carrie/2014/02/statistics-threshold-functionality-101


Abhishek Jadhav