Online Documentation for SQL Administrator for SQL Server

Statistics Editor

Statistics for query optimization are objects that contain statistical information about the distribution of values in one or more columns of a table or indexed view. The query optimizer uses these statistics to estimate the cardinality, or number of rows, in the query result. These cardinality estimates enable the query optimizer to create a high-quality query plan. For example, the query optimizer could use cardinality estimates to choose the index seek operator instead of the more resource-intensive index scan operator, and in doing so improve query performance.

To open statistics in Statistics Editor, double-click it in the Statistics list, or use the Edit Statistics... item of the context menu within the Statistics tab of Table Editor.

• Properties
• Statistics data
• Density vector
• Histogram
• SQL Definition