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 NOEXPAND keyword to query indexed view directly. Since SQL Server 2016 all editions support automatic use of indexed views.