Applies To: SQL Server
Returns statistics information about columns and indexes on the specified table.
|Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Database|
sp_helpstats[ @objname = ] 'object_name' [ , [ @results = ] 'value' ]
[ @objname=] 'object_name'
Specifies the table on which to provide statistics information. object_name is nvarchar(520) and cannot be null. A one- or two-part name can be specified.
[ @results=] 'value'
Specifies the extent of information to provide. Valid entries are ALL and STATS. ALL lists statistics for all indexes and also columns that have statistics created on them; STATS only lists statistics not associated with an index. value is nvarchar(5) with a default of STATS.
0 (success) or 1 (failure)
The following table describes the columns in the result set.
|statistics_name||The name of the statistics. Returns sysname and cannot be null.|
|statistics_keys||The keys on which statistics are based. Returns nvarchar(2078) and cannot be null.|
Use DBCC SHOW_STATISTICS to display detailed statistics information about any particular index or statistics. For more information, see DBCC SHOW_STATISTICS (Transact-SQL) and sp_helpindex (Transact-SQL).
Requires membership in the public role.
The following example creates single-column statistics for all eligible columns for all user tables in the AdventureWorks2012 database by executing
sp_helpstats is run to find the resultant statistics created on the
USE AdventureWorks2012; GO EXEC sp_createstats; GO EXEC sp_helpstats @objname = 'Sales.Customer', @results = 'ALL';
Here is the result set.