Modify Statistics

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL database in Microsoft Fabric

You can modify existing statistics in SQL Server by using SQL Server Management Studio or Transact-SQL.

In This Topic

• Before you begin:

  Security

• To modify statistics, using:

  SQL Server Management Studio

  Transact-SQL

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

1. In Object Explorer, click the plus sign to expand the database in which you want to modify a statistic.

2. Click the plus sign to expand the Tables folder.

3. Click the plus sign to expand the table in which you want to modify a statistic.

4. Click the plus sign to expand the Statistics folder.

5. Right-click the statistics object that you wish to modify and select Properties.

6. 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.

7. 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).