Sql Server - Table Statistics
Imported Statistics
| Statistics | Is imported | Description |
|---|---|---|
| Row count | Indicates the number of rows in table | |
| Last user query | Time of last user scan | |
| Number of user queries | Number of scans by user queries that did not use 'seek' predicate | |
| Last user update | Time of last user update | |
| Number of user updates | Sum of updates by user queries. This includes Insert, Delete, and Updates representing number of operations done not the actual rows affected. | |
| Last load time | - |
Sql Server import usage statistics only for indexed tables and views.
Requirements
Dataedo requires access to the following tables and views:
- sys.all_objects
- sys.dm_db_index_usage_stats
- sys.partitions
- sys.schemas
- sys.tables
- sys.views
Limitations
- The data comes from system tables/views that are cleared upon server restart. In such cases, statistics from the period between the last import and the restart will be lost
- On SQL Server Standard edition to collect usage statistics query must have
NOEXPANDkeyword to query indexed view directly. Since SQL Server 2016 all editions support automatic use of indexed views.
