How to create statistics on SQL Server

A few days ago, I saw someone asking why I couldn't see SQL server statistics on a table. This table is a newly created heap table with no indexes and has never been accessed. To answer this question, we need to go back to how SQL Server creates and maintains statistics.

 

SQL Server creates statistics in the following three cases:

 

1. When an index is created, SQL Server automatically creates statistics on the column where the index is located.

 

2. When SQL Server wants to use the statistical information of some cases, it will automatically create the statistical information if no statistical information is found (the premise is to enable automatic statistical information)

 

3. You can use create statistics to manually create statistics.

 

For more information, refer to the two articles.Article:

Understandingsql server statistics

Sqlserver statistics