Determining SQL Optimization

How to:

You can determine which functions are optimized to their SQL counterparts by adapter in the SQL Optimization Report available from the Web Console.
Top of page
x
Procedure: How to Display the SQL Optimization Report
  1. Select Adapters from the main menu.
  2. From the Information section of the ribbon, click the SQL Optimization Report button.

    The Filter SQL Optimization Report page opens, as shown in the following image.

  3. Optionally, select an Adapter Subcategory from the corresponding list box.
  4. Optionally, select a Function Category from the corresponding list box.
  5. Optionally, select the Show Function Description, Show DBCS Configuration, or Show Requirement on parameter value(s) check boxes.
  6. Click Show Report.

The SQL Optimization Report is displayed, as shown in the following image.

iWay Software