Automatic Index Optimization

IndexOptimizer (patented #US020188) provides fast, easy to use, automated index analysis in production. Using the SQL execution statistics, the existing application index design, a workload-based algorithm, and relevant thresholds, IndexOptimizer recommends the indexes you need to optimize the performance of all applications in production.

In large-scale production environments, performance degradation, due to changed usage of running applications, is a common experience. One of the main reasons for this effect is poor index support of the access paths currently chosen by the application. Since we are talking about production, there is no time for an error prone and incomplete manual analysis. The right solutions have to be supplied in the shortest time. This can only be performed by a mechanized analysis of the access paths chosen and subsequent index suggestions that stand for a better support of the application.

Before the implementation of new applications, estimates have been made regarding the future usage of the business functions, their SQL statements, and the relationship of data volumes between the tables. However, experience shows that despite all research, these estimates are often wrong. To make the application a success, outside tuning is required. Therefore, IndexOptimizer is needed to point out those indexes that really support the queries in the application. In the "real world" of application development, due dates often drop short of the time required for good index design. Once into production, the focus is shifted from application release deadlines to application performance. Suddenly, the unacceptability of poor performance is where the pressure lies.

ERP packages, such as PeopleSoft or SAP R/3, are delivered with a onesize-fits-all index design that does not necessarily match your needs. Since a manual analysis of the thousands of tables in such packages is impossible in a reasonable time, a fast and efficient way is needed to customize your ERP. The queries that are delivered are not designed for change by the customer; therefore, the only way to improve application performance is to build the right indexes, which can be done using IndexOptimizer.

Key Benefits

• Improve application performance through good index design
• Solve performance problems caused by poor access path selection
• Provide better index design based on the actual application workload in production
• Eliminate error prone and time consuming manual work
• Review all index recommendations online, without handling bulky reports

Product Description (PDF, 52 KB)