The Index Impact Analyzer analyzes the performance impact of new indexes on SQL statements before the indexes are permanently created on your database. New indexes may improve the performance of one SQL but downgrade the performance of several others. Index Impact Analyzer evaluates the performance effect that given indexes might have on SQL statements, thereby removing the uncertainty associated with index creation.
The Index Impact Analyzer analyzes the performance impact of index creation on SQL statements retrieved from the SQL Repository or the SQL Scanner. To analyze the impact the creation of new indexes might have on SQL performance, the proposed indexes are created on the database. Then new query plans are retrieved showing the impact the new indexes have on the query plans of individual SQL statements. The new indexes are dropped after the retrieval of the query plans.
After the analysis is complete, the Index Impact Analyzer provides metrics of the overall performance changes and allows you to identify which SQL statements experienced query plan changes with the proposed indexes.
The Index Impact Analyzer window displays the information about the SQL statements that are saved in the Index Impact Analyzer. The display in the right section of the window depends on what is selected in the left pane.
Always displays a tree diagram of the Analyzers and the folders they are stored in.
The right pane displays a variety of different information depending upon what is selected from the tree diagram in the left pane.
You can display information for the following:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center