- Access Path Advisor
- Generates access path recommendations that can improve the performance of a single query.
|
|
✓ |
- Access Path Comparison
- Compares two access paths and displays the results of the comparison. A graphical representation
of the access path flow is provided for each access path along with any meaningful differences in
the plan table for each access path.
|
|
✓ |
- Capture Query Environment
- Captures details about the environment in which you are running an SQL statement. These details
are saved to a file that you can provide to IBM Support when
you are trying to resolve a performance
problem with an SQL statement or that you can use to
re-create an environment on another
subsystem.
|
✓ |
✓ |
- Index Advisor
- Generates recommendations for creating, altering, or dropping indexes that can improve the
performance of a single query. This feature provides the DDL scripts that you can run and
information about the existing indexes from the query that you’re tuning.
|
|
✓ |
- Index Impact Analyzer
- Generates a report that shows the impact of applying the index changes that are recommended by Index Advisor and Workload Index Advisor.
|
|
✓ |
- Job Management
- Enables you to query information about SQL Tuning Services jobs and cancel, delete, and view the
results of SQL Tuning Services jobs.
|
✓ |
✓ |
- Query Rewrite Advisor
- Evaluates how efficiently a query is written and generates best-practice recommendations
for
rewriting it to improve its performance.
|
|
✓ |
- SQL Annotator
- Gathers statistical information about
database objects that are used for
access path selection and provides a cost estimate for
running a particular query. This information can help you understand how a query is processed by the
Db2 optimizer so that you can determine which other SQL tuning
tools might be able to improve that query's performance.
|
|
✓ |
- SQL Capture
- Retrieves statements from the following sources:
- A user-defined local repository
- A local file
- For dynamic SQL, from the statement cache
- For stabilized dynamic SQL and static SQL, from Db2
catalog tables
- A sequential data set or a member of a partitioned data set (PDS or PDSE)
|
✓ |
✓ |
- SQL Formatter
- Formats an SQL statement for a single query so that you can more easily read and understand the
structure of the statement.
|
✓ |
✓ |
- Statistics Advisor
- Generates a recommended set of RUNSTATS commands to
improve query performance.
|
✓ |
✓ |
- Visual Explain
- Generates a graphical representation and a grid plan table
view of the access paths for an SQL statement. This information is useful for tuning queries for
better performance.
|
✓ |
✓ |
- Virtual Index Analyzer
- Virtually tests indexes to determine if the performance of a single query can be improved by creating or dropping the indexes.
|
|
✓ |
- Workload Access Path Advisor
- Generates recommendations for improving the access paths that are used by an SQL workload.
|
|
✓ |
- Workload Access Path Comparison
- Compares, annotates, and generates reports on the access plans and estimated cost changes for
SQL statements in different packages or workloads.
|
|
✓ |
- Workload Analytics Acceleration Advisor
- Generates a report that shows the eligible and ineligible statements for offloading to IBM Db2 Analytics Accelerator and quantifies the CPU savings that can be made by offloading.
|
|
✓ |
- Workload Candidate Acceleration Analyzer
- Generates a report that shows the eligible and ineligible statements for offloading to IBM Db2 Analytics Accelerator and quantifies the CPU savings that can be made by offloading with user input candidate tables.
|
|
✓ |
- Workload Explain
- Gathers explain information for all statements in a workload and stores this information in the
repository database. This information is used by other workload advisors to analyze these
statements.
|
|
✓ |
- Workload Index Advisor
- Generates recommendations for creating, altering, or dropping indexes that can improve
the
performance an SQL workload. This feature provides the DDL scripts that you can run and
information
about the existing indexes from the workload that you’re tuning.
|
|
✓ |
- Workload Management
- Provides a set of APIs for common workload-related tasks such as creating, updating,
And
deleting workloads, listing the statements in a workload, refining workload results by applying
filter criteria, and so on.
|
|
✓ |
- Workload Query Environment Collector
- Captures details about the environment in which you are running an SQL workload. These details
are saved to a file that you can provide to IBM Support when you are trying to resolve a performance
problem with an SQL workload or that you can use to re-create an environment on another
subsystem.
|
|
✓ |
- Workload Query Rewrite Advisor
- Generates recommendations for rewriting statements in an SQL workload to improve its overall
performance.
|
|
✓ |
- Workload Statistics Advisor
- Generates recommendations and RUNSTATS DDL for creating or modifying statistical views.
|
|
✓ |
- Workload Virtual Index Analyzer
- Virtually tests indexes to determine if the performance of a workload can be improved by creating or dropping the indexes.
|
|
✓ |