Testing candidate indexes for single SQL statements that run on DB2 for z/OS

Use the Test Candidate Indexes page of the Invoke section to create and test indexes virtually. If the performance improvement due to an index meets your requirements, you can run the DDL statement to create the index.

Before you begin

Procedure

To open the Test Candidate Indexes page:

  1. On the left side of the Invoke section, expand Advanced under Single Query.
  2. Select Test Candidate Indexes.

What to do next

For help with the Test Candidate Indexes page, click the Help icon (Help), or click in a portion of the page and type F1.

Feedback