Oracle provides optimization hint that can be added to the syntax of a SQL statements to attempt to influence the execution plan that the database optimizer will use to execute the SQL statement. Ques...
When you are optimizing a complicated SQL statement, Quest SQL Optimizer is capable of generating hundred to even thousands of SQL alternatives. While theoretical this may be nice, it is not practical...
When you are executing SQL statements to find which one is the best, you need to take into consideration the factors that can skew the accuracy of the results of the testing. These factors include cac...
This tip explains the order in which the alternative SQL statements are displayed in the Tuning Lab. After the optimization process is finished, the SQL alternatives are displayed in the order of the...
This tips covers the options for terminating the SQL alternatives when they are executed in the Batch Run in the Optimize SQL module. The SQL optimization process in the Optimize SQL module generates ...
This tip covers how to consider the disk I/O when selecting the best SQL alternative. When selecting the best performing SQL statement for your application, how should disk I/O be weighed in compariso...
When you are executing SQL statements to find which one is the best, you need to take into consideration the factors that can skew the accuracy of the results of the testing. These factors include cac...
When you are executing SQL statements to find which one is the best, you need to take into consideration the factors that can skew the accuracy of the test results. These factors include caching the d...
This tip explains how Quest SQL Optimizer selects which SQL alternatives to execute first in the Batch Run. The Optimize SQL | Optimizer | Batch Run | Order and Termination | Execution Order option e...
This tip explains how the Oracle optimization hints are applied to the SQL statements to generate more execution plans in Quest SQL Optimizer for Oracle. One technique that you can use to improve the...
This tip explains how you can view the SQL alternatives generating in the Batch Optimizer in the Tuning Lab. After a SQL statement has been optimized in the Batch Optimizer in Quest SQL Optimizer for...
This tip covers using the batch optimization process when your database is set to run with the rule based optimizer. In the Batch Optimizer in Quest SQL Optimizer for Oracle you may notice that the o...
