Use the Analyze tool to view and collect statistics, validate structure and list chained rows for database structures such as tables, clusters and indexes.
Ways to open the Analyze Tool
From DB Navigator |
|
From the Explain Plan Tool |
|
Select the collection method.
Collection Method |
Description |
---|---|
Compute Statistics |
The entire object is scanned to gather data. The larger the object, the longer it takes to complete the analysis. Select this option only if the object is small. |
Estimate Statistics |
Sample by rows or percentage of the object. The accuracy of the statistics depends on the representatives of the sampling. This option suits large objects. |
Delete Statistics |
Delete the statistics gathered for the object. |
Use to verify the integrity of the selected object.
Select Cascade to additionally verify dependent objects. For example, if you validate the structure of a cluster and select Cascade, SQL Navigator checks all tables and indexes in the cluster.
|
Note: Oracle returns an error message if it encounters corruption in the structure of an object. To fix errors: Drop and recreate the object from the commands on the Object Menu. |
Use to identify migrated or chained rows in a table or cluster. Having a high percentage of chained rows can impair application performance. UPDATE statements that cause migration and chaining perform poorly. Queries that select migrated or chained rows must perform more I/O than those that do not. For these reasons, it is important to detect and correct them. See Oracle documentation on the possible ways of fixing chained-rows problems.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center