Use this page of the Options dialog to specify customized optimization settings for SQL Rewrite.
To enable the options on this page if disabled, go to Optimize SQL | Optimizer | Intelligence in the Options dialog and select Custom Settings. See Intelligence (Optimize SQL) for more information.
To set quota options
Click in the main menu.
Select Optimize SQL | Optimizer | Quota.
Specify quotas to use in optimization. Review the following for additional information:
Quota for SQL Alternatives Generated |
Description |
Syntax transformation quota |
Enter the maximum number of SQL statements generated by applying syntax transformation rules in the artificial intelligence engine. |
Hints quota |
Enter the maximum number of SQL statements generated by applying Oracle optimization hints. |
Quota for Rearranging the Driving Path |
Description |
Table join permutation quota |
Enter the maximum number of join rearrangements attempted to generate a new table join access path during optimization. |
Use this page of the Options dialog to specify default index generation options for SQL Rewrite. Settings specified through the Options dialog apply to new SQL Rewrite sessions.
Settings specified through the Current Session dialog override the global settings and apply to the current session only. See Optimize SQL Statements for more information.
To set intelligence options
Click in the main menu.
Select Optimize SQL | Index Generation | Intelligence.
Select a method for defining index generation options. Review the following for additional information:
Intelligence |
Select one of the following:
|
Use this page of the Options dialog to specify customized index generation settings for SQL Rewrite.
To enable all options on this page if disabled, go to Optimize SQL | Index Generation | Intelligence in the Options dialog and select Custom Settings. See Intelligence (Index Generation) for more information.
To set index generation options
Select Optimize SQL | Index Generation | Options.
Select custom settings to use for index generation. Review the following for additional information:
Index Generation Options |
Description |
Sampling Block with maximum size |
Enter the Sample Block size to use to estimate the selectivity of data for a potential index. Note: This value is only used if you are connected to a database using Oracle 9i or later. |
Maximum number of records (if Sample Block is not available) |
Enter the number or records to use to estimate the selectivity of data for a potential index if the Oracle Sample Block command is not available. |
Automatically enforce cost based index simulation when statistics are not collected |
Select to use cost based index simulation when statistics are not available. Tip: Select ALL_ROWS or FIRST_ROWS to use these Oracle optimization hints when using cost based index simulation. |
Evaluate columns in SELECT list |
Select to evaluate creating an index on columns in the SELECT list. |
Quota |
Description |
Index generation quota |
Enter the maximum number of index alternatives to generate. |
Index set generation quota |
Enter the maximum number of index sets to generate. |
Index Prefix |
Description |
Default prefix of index name |
Enter the prefix placed on the name of index alternatives. Default: QUEST_SX_IDX |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center