Index SmartGuide -- Overview

Use the Index SmartGuide to determine which indexes to create for a given set of SQL statements. The SmartGuide will make recommendations based on the workload that you specify. If the workload does not accurately reflect actual statements executed against your database, the recommendations will not improve the performance of your database.

Tasks

• Creating indexes using a SmartGuide
• Creating a workload
• Editing a workload
• Adding a SQL statement to a workload
• Changing a SQL statement in a workload
• Importing SQL statements
• Altering the optimization algorithm parameters
• Viewing workload details
• Viewing a SQL statement in a workload

Page controls

• Introduction
• Workload (Define a new workload)
• Workload (Select a workload)
• Limits
• Calculate
• Recommendations
• Drop
• Summary

Fields and controls

• Back
• Next
• Done
• Show SQL (on summary page only)
• Cancel

Related information

• Privileges -- Overview
• Journal -- Overview
• Altering an index
• Creating an index
• Showing commands or SQL
• Showing related objects
• Showing the results of a job
• See the db2advis command in the Command Reference .
• See the Administration Guide .