The Scanned SQL Viewer window enables the viewing and analysis of the SQL statement scanned. It displays the formatted scanned SQL statement, access plan, temp table (if applicable), and information about the SQL statement.
Formatted scanned SQL statement
Access plan
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 access 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
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
