Page History
This section includes the following topics:
- About the Objects tab
- How the Objects tab is structured
- About the entities you can examine in the Objects tab
- How the Objects tab can help you identify performance problems
| Anchor | ||||
|---|---|---|---|---|
|
The Objects tab is a comprehensive browser, which allows you to understand the relationships and associations between database schema objects. It enables a more productive tuning process by reducing the need of another tool for exploring the Sybase catalog tables.
The Objects tab also allows you to observe storage utilization, over time, at varying levels, such as, database, segment, database device, and so on.
| Anchor | ||||
|---|---|---|---|---|
|
The Objects tab displays information on a selected entity and its associated entities. When you open the Objects tab the selected entity is by default Instance, meaning that information is displayed on the instance level. When you launch the Objects tab from the Activity tab with the database entity - the tab is launched in-context with the database you selected in the Activity tab.
...
See About Precise for Sybase tabs on page 15.
| Anchor | ||||
|---|---|---|---|---|
|
The Objects tab displays information on different entities. This section provides an overview of all entities, their meaning, and their views.
...
The Index entity displays general details regarding space utilization for the selected index. The following views are available:
- Optdiag
...
- Statistics
About getting an overview of index entities
...
Rows Displays the number of rows in the underlying table during the selected time frame, as collected by the Collection Space Utilization process.
About viewing data storage and fragmentation information for the selected index
...
Data row cluster ratio This is a measure of the clustering of data rows on pages with respect to the index key order. This ratio helps in estimating the cost of using a non-clustered index, or a clustered index on a DOL table.
About viewing clustered index details
...
The Column entity displays general details for the selected column. The following views are available:• Overview
- Overview
...
- Column Statistics
About getting an overview of the selected column
...
This view shows column-level statistics including:• Statistics
- Statistics giving the density and selectivity of columns.
...
- A histogram, if the table contains one or more rows of data at the time the index is created or update statistics is run. There is a histogram for the leading column for:
...
- Each index that currently exists (if there was at least one non-null value in the column when the index was created).
...
- Any indexes that have been created and dropped (as long as delete statistics has not been run).
...
- Any column list on which update statistics has been run. There is also a histogram for:
...
- Every column in an index, if the update index statistics command was used.
...
- Every column in the table, if the update all statistics command was used.
...
The following information is displayed:
...
You can view general details on the entities that can be associated to the selected User entity in the Association area. It is possible to associate to the User entity from the Database entity.
About the Database Device entity
The Database Device entity displays general details, I/O Activity and storage information on the selected device. The following views are available:• Overview
- Overview
...
- Statistics
About getting an overview of the database device entity
...
Pages requested Displays the I/O Activity (pages read and written) during the selected time frame for the selected device, as collected by the Collect Statistics process.
Database Device entity Association area
...
The Data Cache entity displays general information about the selected Data Cache. The following views are available:• Overview
- Overview
...
- Data cache pools
About getting an overview of data cache pools
...
The Statement entity displays statements associated to tables and indexes in the Object tab. The following views are available:• Overview
- Overview
...
- Performance
...
- SQL text
About getting an overview of a statement
...
The table below describes the information displayed in the Performance tab.
Table 7-2 Performance 2 Performance tab
Column Description
Launch icon to SQL tab Launches into SQL tab.
...
Text Displays the statement's text.
The table below describes the information displayed in the Plan tab.
Table 7-3 Plan 3 Plan tab
Column Description
Launch icon to SQL tab Launches into SQL tab.
...
The Batch entity displays batches associated to tables and indexes in the Object tab. The following views are available:• Overview
- Overview
...
- Performance
...
- SQL text
About getting an overview of batch details
...
Access Plan Displays a list of all Access operators in the batch’s explain results.
About viewing the performance of a batch
...
The table below describes the information displayed in the Performance tab.
Table 7-4 Batch 4 Batch entity Performance tab
Column Description
...
The table below describes the information displayed in the Plan tab.
Table 7-5 Batch 5 Batch entity Plan tab
Column Description
...
Parallel Access Displays Yes or No.
| Anchor | ||||
|---|---|---|---|---|
|
It is possible to use the Objects tab to identify performance problems by:• See
- See Examining an object's space usage over time on page 80.
...
- See Examining fragmentation of table data and indexes on page 80.
...
- See Examining distribution statistics of indexes and columns on page 80.
Examining an object's space usage over time
...
To examine fragmentation of table data and indexes1. Use
- 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 About the Table entity and Tables Contain Same Column entity on page 69.
See About the View entity and Views Contain Same Column entity on page 74.
...
To examine distribution statistics of indexes and columns1. Use , use the Statistics view of the Column entity to help you see the distribution of values in that column. See About viewing density and selectivity statistics on page 73.
See About viewing column statistics on page 73.
Precise. Performance intelligence from click to storage. Learn more > >
...