Menu
DBCC SHOW_STATISTICS – CREATE DATABASE dbName; GO

DBCC SHOW_STATISTICS – CREATE DATABASE dbName; GO

This command will display the current optimization statistics for a table or view. Before you can show the statistics, you first need to create them. The following snippet illustrates how this is done. Provide a statistics name, the table (e.g., READING), and the column (e.g., VALUE) for which you want to capture statistics: CREATE STATISTICS […]