Modify Statistics
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
You can modify existing statistics in SQL Server by using SQL Server Management Studio or Transact-SQL.
In This Topic
Before you begin:
To modify statistics, using:
Before You Begin
Security
Permissions
Requires that:
The user has ALTER permission on the table or view.
The user be the table or indexed view owner, or a member of one of the following roles: sysadmin fixed server role, db_owner fixed database role, or the db_ddladmin fixed database role.
Using SQL Server Management Studio
To modify statistics
In Object Explorer, click the plus sign to expand the database in which you want to modify a statistic.
Click the plus sign to expand the Tables folder.
Click the plus sign to expand the table in which you want to modify a statistic.
Click the plus sign to expand the Statistics folder.
Right-click the statistics object that you wish to modify and select Properties.
In the Statistics Properties - statistics_name dialog box, on the General page, click Add, Remove, Move Up, or Move Down, or any combination, to alter the properties of the statistics. Remember that a column's location within the Statistics Columns grid can substantially impact the usefulness of the statistics.
Click OK.
Using Transact-SQL
To modify statistics
This task cannot be performed using Transact-SQL statements. To modify statistics using Transact-SQL, you must first delete the existing statistic and then re-create it with new attributes.
For more information, see DROP STATISTICS (Transact-SQL) and CREATE STATISTICS (Transact-SQL).
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for