Quota Options
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To set quota options
- Click
. -
Select Optimize SQL | SQL Rewrite | Quota
-
Review the following for additional information:
Quota Description Syntax Transformation Quota
Specify the maximum number of SQL statements generated by applying SQL transformation rules. This quota affects how many SQL statements are created by changing the SQL syntax. The default quota of 100 is normally sufficient for most of the complicated SQL statements. However, the quota can be increased to tackle exceptionally complicated SQL statements with very high levels of table joins or multiple levels of nested sub-queries.
SQL Options Quota
Specify the maximum number of SQL statements to be generated by applying SQL options. Total Quota
This is a read-only field indicating the maximum number of SQL statements generated during SQL Rewrite. This figure consists of: Syntax Transformation Quota + SQL Options Quota.
Related Topics