Page History
...
Table 7-4 Indexes on Table.
Column Description
...
| Column | Description |
|---|---|
 | Click to launch to Objects tab—with the selected index in context—to get additional catalog information about the object. |
 |
...
| Click to locate and highlight in Bold font all the operators in the execution plan that access the specified index. |
| Index |
...
| Name | Name of the index. |
| Contribution |
...
| Ratio | The Contribution ratio of the table, computed by I/O Cost. |
| Prefetch |
...
| The Prefetch type (LIST, SEQUENTIAL, or NONE). |
| Statistics |
...
| Time | The last statistics update. |
| Unique |
...
| Rule | Unique rule based on last statistics update. |
| Cluster |
...
| Ratio | Cluster ratio based on last statistics update. |
| Cluster |
...
| Factor | Cluster factor based on last statistics update. |
| Index |
...
| Leafs | Index leafs based on last statistics update. |
| Index |
...
| Levels | Index levels based on last statistics update. |
| Distinct First |
...
| Keys | Distinct first key based on last statistics update. |
| Distinct Full |
...
| Keys | Distinct full keys based on last statistics update. |
| Sequential |
...
| Pages | Sequential pages based on last statistics update. |
| Density |
...
| Density based on last statistics update. |
The following table describes the information displayed in Columns in Table.
...