I have a series of indexes that are showing as statistics. Is it because they are filtered or are defined as constraints?
Technology Tips and News
I have a series of indexes that are showing as statistics. Is it because they are filtered or are defined as constraints?
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Name Updated Rows Rows Sampled Steps Density Average Key Length String Index -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- $pk_act Jun 16 2015 2:00AM 386983 386983 33 1 5 NO 386983 All Density Average Length Columns -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2.584093E-06 5 id Histogram Steps RANGE_HI_KEY RANGE_ROWS EQ_ROWS DISTINCT_RANGE_ROWS AVG_RANGE_ROWS -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 0 0 1 0 1 31812 29894 1 29894 1 34151 2047
Hello John,
That's a misunderstanding. By default the database Option AUTO_CREATE_STATISTICS is set to on and then for each new index a corresponding statistic will be created with the same name; see Statistics
You can validate it by querying sys.stats => column "auto_created"
select * from sys.stats