Display the query environment

Changing your query environment can affect how your query performs. To view the query environment settings:

  1. Open a query graph.
  2. Select Display query environment from the View menu.
  3. Or you can right-click on the Final Select icon and select Environment Settings.
  4. The query environment attributes are displayed in the Icon attributes and values.

You can change your query environment by using the Change query attributes function.

  • Changing settings on the Performance tab of the JDBC setup dialog in Run SQL Scripts.
  • For some tips on optimization, see Tips for improving query performance.

    For more information, see Database Performance and Query Optimization in the i5/OS Information Center Link to Information center.