Page History
...
Table 9-5 Tables used in the plan
Column Description
...
| Column | Description |
|---|---|
 | Click to launch the Objects tab and focus on the specified table. |
 |
...
| Click to locate and highlight all the operators in the Execution Plan that access the specified table. |
...
| Used | Indicates whether the specified table is used in the selected operator in the Execution Plan tree. |
| Table |
...
| Displays the full table name ([Database Name].[Owner].[Table Name]). |
...
| Cost | Total cost of the operators that accessed the specified table. |
| Cost (%) |
...
| Total cost in percentage of the operator that accessed the specified table. | |
| Rows |
...
| Number of rows in the specified table. |
| Pages |
...
| Allocated | The number of pages allocated in the disk for the table records. The value might be incorrect due to out-of-date space usage information. If you suspect the value to be incorrect, use the sp_flushstats command to flush current space usage information from memory or run |
...
the update statistics command to recalculate the space usage fields. |
| Pages |
...
| Used | The number of pages used in the disk for the table records. The value might be incorrect due to out-of-date space usage information. If you suspect the value to be incorrect, use |
...
the sp_flushstats command to flush current space usage information from memory or run the update statistics command to recalculate the space usage fields. |
About indexes of table
Displays a list of all the indexes of the selected table displayed in Tables Used in the Plan. The table below describes the information displayed in indexes of table.
Table 9-6 Indexes of table
Column Description
...
| Column | Description |
|---|---|
| Click to launch the Objects tab and focus on the specified index. |
|
...
| Click 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 sp_flushstats command to flush current space usage information from memory or run the update statistics command to recalculate the space usage fields. |
| 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 sp_flushstats command to flush current space usage information from memory or run the update statistics command to recalculate the space usage fields. |
| Cost |
...
| Total cost of the operators that accessed the specified index. |
| Cost (%) |
...
| Total cost in percentage of the operators that accessed the specified index. | |
| Index |
...
| Depth | Number of levels in the index. |
...
| Unique | Indicates whether the index is unique. |
| Clustered |
...
| Indicates whether the index is clustered. |
About Columns of Table
Displays a list of all columns in the selected table displayed in Tables Used in Plan. 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.
...
Table 9-7 Columns of table
Column Description
Indicates whether the column is part of the selected index and whether it is sorted in ascending or descending order.
...