Complex SQL
View SQL Classification - Complex page
SQL statements are classified as Complex SQL if they meet any one of the following requirements and do not meet any requirement for being a Problematic SQL statement:
Number of table operations (Default = 2 /3, Range 2 to 99)
Specify the number of table references in the query plan for Complex SQL statements. Checkboxes are available to indicate whether you want the inserted and deleted simulated temp tables to be included in this table range.
You can specify to include or exclude inserted and deleted simulation temporary tables created in the SQL Scanner Trigger Conversion by using the Including inserted simulation temp table and Including deleted simulation temp table checkboxes.
With full index scan (Default = checked)
Specify whether SQL statements with full index scan are classified as Complex SQL statements.