Export (0) Print
Expand All
Expand Minimize

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft