STEP 2 – I inserted around 40000 rows.
STEP 3 – If we run the DBCC SHOW_STATISTICS, I have empty result set.
STEP 3 – Running the sys.dm_db_index_operational_stats I saw 40002 inserted correctly on the index.
STEP 4 – Running the sys.dm_db_partition_stats I saw 40002 inserted correctly on the index.
STEP 5 – As we explained, if you run any query and the number of updates are greater of 20% of the total of the rows and this query is using any field that the statistics is based, you will get an update statistics.
STEP 6 – On the same way, you will get an updated/delete statistics when you update data if this is more 20% of total rows.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.