Page History
...
Table 10-4 Indexes defined on
Column Description
...
Column | Description |
---|---|
Click to launch to the Objects tab with the selected index in context. |
...
Click the Locator icon to locate and highlight all the operators in the execution plan that access the specified index. | |
Used |
...
Indicates whether the specified index is used in the selected operator in the execution plan tree. |
Index |
...
Displays the index name. |
Pages |
...
Allocated | The number of pages allocated in the disk for the index records. The value may be incorrect due to out-of-date space usage information. If you suspect the value to be incorrect, use the DBCC UPDATEUSAGE command to recalculate the space usage fields. See SQL Server Books Online for |
Pages |
...
Used | The number of pages used in the disk for the index records. The value may be incorrect due to out-of-date space usage information. If you suspect the value to be incorrect, use the DBCC UPDATEUSAGE command to recalculate the space usage fields. See SQL Server Books Online for |
...
Cost | Total cost of the access of the steps to the specified index. |
Cost (%) |
...
Total cost in percentage of the access of the steps to the specified index. | |
Last Statistics |
...
Calculations | The SQL Server collects statistics for each index and updates them automatically. This column displays the date that the statistics for the specified index was last updated. |
Index |
...
Depth | Number of levels in the index. |
...
Unique | Indicates whether the index is unique. |
Clustered |
...
Indicates whether the index is clustered. |
About columns in table
Displays a list of all columns in the selected table displayed in Tables in use. When an index is selected in Indexes of Table, the first column constitutes the index column sorted by the position of the column in the index, and marked with an Ascending or Descending icon.
The following table describes the information displayed in Columns in Table.
Table 10-5 Columns table
Column Description
...
Column | Description |
---|---|
Indicates whether the column is part of the selected index and is sorted in ascending order. | |
...
Indicates whether the column is part of the selected index and is sorted in descending order. |
Column |
...
Displays the column name. |
Type |
...
Displays the physical storage type of the column. |
Key |
...
Number | Displays the key number of the index column. |
Used in |
...
Operator | Indicates whether the column is used in the selected operator in the Execution plan tree. |
In |
...
Clause | Displays a list of all the clauses that the specified column participates in. |
About viewing statistical information on all operators in the execution plan
The Statistics tab displays statistical information of all operators in the Execution plan tree. When you sort a table, you can locate operators by their estimated cost or by any other column in the table.
...
Table 10-6 Execution plan statistics
Column Description
...
Column | Description |
---|---|
Locates and highlights the operator in the execution plan tree that matches the selected operator in the grid. | |
Operator ID and |
...
Type | Displays the operator ID and type. |
Subtree |
...
Cost | Displays the cost of the operators and its sub-operators. |
Estimated |
...
Cost | Displays the estimated cost of the current operation. A high cost value may indicate a problem in the current implementation of the operation. If the cost value is greater than "1", it is highlighted in red. Check the Estimated I/O cost and Estimated CPU cost values to determine whether the operation is an I/O consuming operation or a CPU consuming operation (or both). |
Estimated Cost (%) |
...
Displays the estimated cost (in percentage) of the current operator. | |
Estimated CPU |
...
Cost | Displays the estimated CPU cost of the current operation. A high cost value may indicate a problem in the current implementation of the operation. If the cost value is greater than "1", it is highlighted in red. |
Estimated I/O |
...
Cost | Displays the estimated I/O cost of the current operation. A high cost value may indicate a problem in the current implementation of the operation. If the cost value is greater than "1", it is highlighted in red. |
Estimated |
...
Rows | Displays the estimated number of rows returned from the current operation. |
Avg Row |
...
Size | Displays the estimated average row size of the rows affected by current operation. |
...
Parallel | Indicates whether the operator is running in parallel. |
About displaying information on operation types (More tab > Operations)
The Operations option displays statistical information broken down into operation types of all operators in the Execution plan tree.
...
Table 10-7 Major operations
Column Description
...
Column | Description |
---|---|
Locates and highlights the operators in the Execution plan tree that match the selected major operation type. | |
Major Operation |
...
Type | Displays the major types of the operators. The operators in the Execution plan tree are separated into the following major types: |
...
|
...
|
...
|
...
|
...
|
Estimated |
...
Cost | Displays the total estimated cost breakdown according to major operation types. |
...
Operations | Indicates the number of operators of specified major operation type. |
...
Objects | Indicates the number of referenced tables/indexes of the specified operation type. This column is only relevant for Table and Index operation types. |
The following table shows information on regular operation types.
Table 10-8 Operations
Column Description
...
Column | Description |
---|---|
Locates and highlights the operators in the Execution plan tree that match the selected operation type. | |
Operation |
...
Type | Indicates the type of operator, such as |
...
Clustered Index Scan, Index Seek, Nested Loop, etc. |
Major Operation |
...
Type | Displays the major types of the operators. The operators in the Execution plan tree are separated into the following major types: |
...
|
...
|
...
|
...
|
...
|
Estimated |
...
Cost | Displays the total estimated cost breakdown according to operation types. |
...
Operations | Indicates the number of operators of |
...
specified major operation type. |
...
Objects | Indicates the number of referenced tables/indexes of the specified operation type. |
About viewing general properties of a selected statement (More tab > Properties)
The Properties option displays general details of the selected statement.
...