Page History
...
From the Association area, you can also drill down to another entity by clicking a table row. A drilldown drill-down affects the whole tab: When you drill down to another entity, the Tab heading reflects the new selection, the Main area displays information on the newly selected entity, and the Association area shows data on its associated entities.
...
In the Association area, click the row of the database you want to view detailed information for. The Tab heading indicates the newly selected entity; the Main area displays an overview of the database you want to investigate, and the Association area shows general details on the tables that are associated with the database you selected. See For more information about Precise for Sybase tabs, see About Precise for Sybase tabs on page 15.
| Anchor | ||||
|---|---|---|---|---|
|
...
- Use the Optdiag view in the Table or Index entity to observe fragmentation information.
- Determine whether the table or index is heavily fragmented and needs to be reorganized. See For more information about table and view entities, see About the Table entity and Tables Contain Same Column entity on page 69.
...
- and About the View entity and Views Contain Same Column entity
...
- .
| Anchor | ||||
|---|---|---|---|---|
|
...
To examine distribution statistics of indexes and columns, use the Statistics view of the Column entity to help you see the distribution of values in that column. See For more information about viewing these statistics, see About viewing density and selectivity statistics on page 73.See and About viewing column statistics on page 73.
Precise. Performance intelligence from click to storage. Learn more > >
...