Chat now with support
Chat with Support

SQL Optimizer for DB2 ZOS 5.6.1 - User Guide

Welcome Optimize SQL Options Tutorial About us Third-party contributions Copyright

View Schema Information

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To view schema information

  1. Select the SQL Details tab in the main window.
  2. Select the Schema Information tab in the Optimize SQL window.

  3. Click beside the Summary list and select a table for additional information.

  

Related Topics  

View Bind Variables

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To view bind variables

  1. Select the SQL Details tab in the main window.
  2. Select the Bind Variables tab in the Optimize SQL window.

The parameters for the bind variable defined for your SQL statement display. Set Bind Variables

Note: Information is only displayed in this tab if you used variables for optimization.

  

Related Topics 

View Schema Information

Show or Hide Table Attributes

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To show or hide a table attribute

  1. Select the SQL Details tab in the main window.
  2. Select the Schema Information tab in the Optimize SQL window.

  3. Right-click the header row in the Summary Details pane and select Column Chooser.

  4. Add or remove table attributes by dragging the column names to and from the Customization dialog.

  

Related Topics

Show or Hide Column Attributes

Show or Hide Column Attributes

Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To show or hide a column attribute

  1. Select the SQL Details tab in the main window.
  2. Select the Schema Information tab in the Optimize SQL window.

  3. Click besides the Summary list and select a table.

  4. Right-click the header row of the Column Attributes pane and select Column Chooser.

  5. Add or remove column attributes by dragging the column names to and from the Customization dialog.

  

Related Topics  

Show or Hide Table Attributes

Related Documents