Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Contains a row for each statistic of a tabular object of the type U, V, or TF.
Note
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. |
See Also
Reference
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
Other Resources
Querying the SQL Server System Catalog FAQ