Modify Statistics

  • Article

You can modify existing statistics in SQL Server 2012 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.

Arrow icon used with Back to Top link [Top]

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

Arrow icon used with Back to Top link [Top]