This tip covers the importance of finding the best “driving path” for retrieving rows from the database. We’ll use a simple illustration of a Nested Loop operation that retrieves data accessing 2 tab...
This tips covers optimizing SQL statements that use a VIEW in place of a TABLE. In early versions of the Oracle database, a VIEW was handled like a temporary table that stores the temporary data from...
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...
When you optimize a simple SQL statement, Quest SQL Optimizer may only generate a few SQL alternatives using the default settings in the Optimizer options. It is very likely that many more alternative...
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 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 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 covers the expectation that Quest SQL Optimizer will always be able to improve the performance of your SQL statements. Occasionally, even when you have increased the intelligence level up to...
This tip sheds some insight on why the SQL optimization process can take hours to run and what you can do to shorten the process. SQL Statement with Views When the SQL statement is using Views inst...
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...
