Stats Recollection Skipping | System Threshold | Change based Threshold
We are seeing an issue while re-collecting a stat on a table. Explain plan is provided below.
Explain COLLECT STATISTICS DB.TableName INDEX (Col1, Col2);
1) First, we lockDB.TableName for access.
2) Next, We SKIP collecting STATISTICS for (
'Col1', 'Col2'), because the age of the
statistics (131 days) does not exceed the system-determined time
threshold of 9999 days and the estimated data change of 9,999.98 %
does not exceed the system-determined change threshold of 9,999.98
Rest of the stats on the same table are re-collected. Iinitially i had a guess that may be this stat was collected with Change-Based Threshold option of "THRESHOLD 9999 PERCENT AND THRESHOLD 9999 DAYS". So, If this was the case then it should have shown UCT9999.00UTT9999 in Threshold Signature column of dbc.StatsV but it shows Global Threshold in the field.
Lastly, this stats was created back in 2014 and its skip count is near to 800.
Rest of the stats on different tables are using system threshold and are working fine. From where this stat is possibly checking for these threshold values ?