Skip to content

modify-statistics.md

Latest commit

 

History

History
68 lines (43 loc) · 2.7 KB

modify-statistics.md

File metadata and controls

68 lines (43 loc) · 2.7 KB
title Modify Statistics | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology performance
ms.topic conceptual
helpviewer_keywords
statistics [SQL Server], modifying
modifying statistics
ms.assetid b06299ca-ed52-411a-b245-45eac4628c99
author MikeRayMSFT
ms.author mikeray
manager craigg

Modify Statistics

You can modify existing statistics in [!INCLUDEssCurrent] by using [!INCLUDEssManStudioFull] or [!INCLUDEtsql].

In This Topic

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