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 select query transformation hints
Click in the main menu.
Select Optimize SQL | Optimizer | Hints | Query Transformations.
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 select join order / operation hints
Click in the main menu.
Select Optimize SQL | Optimizer | Hints | Join Orders / Operations.
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 select join order / operation hints
Click in the main menu.
Select Optimize SQL | Optimizer | Hints | Parallel Execution.
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 select other hints
Click in the main menu.
Select Optimize SQL | Optimizer | Hints | Other.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center