Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - Release Notes

Complex SQL

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.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating