sys.stats (Transact-SQL)
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

sys.stats (Transact-SQL)

Contains a row for each statistic of a tabular object of the type U, V, or TF.

ms177623.note(en-US,SQL.90).gifNote:
Every index will have a corresponding statistics row with the same name and ID (index_id = stats_id), but not every statistics row has a corresponding index.

Column name Data type Description

object_id

int

ID of the object to which these statistics belong.

name

sysname

Name of the statistics. Is unique within the object.

stats_id

int

ID of the statistics. Is unique within the object.

auto_created

bit

Statistics were auto-created by the query processor.

user_created

bit

Statistics were explicitly created by the user.

no_recompute

bit

Statistics were created with the NORECOMPUTE option.

Show:
© 2016 Microsoft