立即与支持人员聊天
与支持团队交流

SQL Optimizer for DB2 LUW 4.4.1 - Release Notes

About Scanned SQL Viewer

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

 

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级