When writing a SQL statement, it is easy to be satisfied when you have figured out how to get the correct results. This is especially true when you are writing a complicated SQL statement. But in orde...
This tip covers executing SQL statements that require you to enter a parameter before the SQL statements are executed. A SQL statement with a variable which is provided at run time poses an extra chal...
This tip covers testing the SQL alternatives in a development environment when it is not possible to do extensive testing in the production environment. When optimizing a SQL statement, you need to t...
This tip covers how to specify the table join syntax which is used when SQL alternatives are generated. When the syntax for SQL statements was originally developed, the conditions of joining tables w...
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...
