Page History
...
Table 10-9 Selected statement properties
Field |
---|
...
Description |
---|
Statement or |
...
Batch | Displays the following information: |
...
|
...
|
...
|
...
Cabinet | Indicates the cabinet in which the statement was saved. This field is only displayed for statements that were edited and saved in the statement workshop (using the Open, Save As, or Edit options). |
Folder |
...
Indicates the folder in which the statement was saved. This field is only displayed for statements that were edited and saved in the statement workshop (using the Open, Save As, or Edit options). |
Access |
...
Plan | Displays the following information: |
...
|
...
|
...
|
...
|
...
|
About viewing recommended indexes or statistics for a statement or batch
Precise for SQL Server uses the Microsoft® Index Tuning Wizard to obtain recommended indexes or statistics for the selected statement or batch so that the optimizer will choose a better access plan and improve the performance of the statement or batch. The Recommend Indexes process only makes recommendations with regards to the addition of indexes or statistics.
...
- Recommended Indexes/Statistics area
- Recommendation details area
About the Recommended Indexes/Statistics area
Displays the indexes or statistics suggested by the Recommend process. The following information is displayed in the Recommended Indexes/Statistics area:
- What-if Select if. Select this check box to determine which recommendations you want to test before actually implementing them. (SQL Server 2005 only)
- Recommendation type icon Icon icon. Icon indicating what type of recommendation is being considered for the table.
- Object Displays Object. Displays the full name (including owner) of the table, partition, or schema, to which the recommendation refers.
- Clustered Indicates Clustered. Indicates whether the index is clustered. This parameter is only relevant for create index recommendations.
- Unique Indicates Unique. Indicates whether the index is unique. This parameter is only relevant for create index recommendations.
- Details Displays Details. Displays a list of the index's or statistic's columns, separated by a comma. The sort order (ascending/descending) is also displayed for recommended indexes.
Displays the name of the index, for the create drop index recommendation.
Displays the name of the file group that the schema defines, for the create partition schema recommendation.
Displays the range defining how the schema should be partitioned, in the create partition function recommendation. Indicates whether data falling on the maximum value in the range will be assigned to the next partition or to the same partition.
About the recommendation type icons
The following icons indicate what type of recommendation is being considered for the table:
Indicates that the recommendation is to create an index.
Indicates that the recommendation is to create a statistic.
Indicates that the recommendation is to create a partition function (for SQL Server 2005 only).
Indicates that the recommendation is to create a partition schema (for SQL Server 2005 only).
Indicates that the recommendation is to drop an index (for SQL Server 2005 only).
About the Recommendation details area
Provides details on the indexes or statistics suggested by the Recommend process.
...
- Columns
- DDL
- Table's Indexes/Statistics
- Text
- What-If
About the Columns tab
Displays a list of all the columns in the recommended index's/statistic's table with the following information:
- Sort order icon Indicates icon. Indicates whether the column is part of the selected index and the order in which it was sorted.
If you are using SQL Server 2005, it is possible to add no-key columns that are not part of the recommended index. In this case, an include icon is displayed, indicating that the column is part of the INCLUDE statement. - Key Number Indicates Number. Indicates the key number of the column in the index. Column Displays
- Column. Displays the name of the column.
- Type Displays Type. Displays the physical storage type of the column.
- Part of Index Indicates Index. Indicates whether the column participates in an existing index.
- First Key of Index Indicates Index. Indicates whether the column participates as the first key in an existing index.
- Used Displays Used. Displays the manner in which the column participates in the statement, according to the following types: Range Scan, Table Scan, Sort and Join.
Info |
---|
...
This tab is not available for create partition function or create partition schema recommendations. |
About the sort order icons
The sort order icons indicate whether the column is part of the selected index and the order in which it was sorted. If you are using SQL Server 2005, it is possible to add no-key columns that are not part of the recommended index. In this case, an include icon is displayed, indicating that the column is part of the INCLUDE statement.
...