Skip to Content
Information
Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

Workload Access Path Compare and Index Advisor report fields

This section lists the fields found on the Workload Access Path Compare or Index Advisors reports.

In the following table, the first column shows whether the field is used in Workload Access Path Compare (WLC), Index Advisor (IA), or both. Other columns display the Db2 column name, the Db2 table or other source, and the section of the report where it appears.

Related topic

Working-with-reports

The hlq.llqSAMP(PSSREPB) layout data set member controls the field labels. The labels shown below are the default labels that are shipped with SQL Performance. For information about customizing the layout of your reports, see Changing-the-layout-of-the-compare-report.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

SQL Performance for DB2 13.1