Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9 - Installation Guide

Review Scanned SQL

The SQL Text pane and the SQL Information pane in SQL Scanner window enables the viewing and analysis of the SQL statements scanned. The following information is provided:

  • Formatted scanned SQL statement

  • Query plan

  • Abstract plan

  • Trace on

  • SQL Information

  • SQL statement type classification: Problematic, Complex, Simple, or Invalid.
  • Database error message if SQL is classified as Invalid.
  • Information about any SQL conversion the SQL Scanner applied to the SQL statement in order for it to generate a query plan.
  • Line and column where the SQL statement was found in the source (for database object and source code files only)
  • SQL statement used to create and populate any temporary tables the SQL Scanner created

  • Checked SQL Information (if the SQL has been marked as checked)

  • Date time of when the SQL statement was checked
  • Name of who checked the SQL
  • Status
  • Checked description are displayed

Note: When the SQL Scanner finds a SQL statement that contains a variable, it will assign the BINARY data type to the variable as it retrieves the execution plan.

To assign a different data type to the variable

  1. Copy the SQL statement to the SQL Editor pane in the SQL Optimizer window.

  2. Click Show Plan image\B_ShowPlan.gif.

  3. Select the data type from the Parameters window which automatically displays when you have a variable in a SQL statement.

  4. Click OK.

 

Related Topic

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating