Scan SQL
Scan SQL
Scan SQL helps you identify problematic SQL statements in your database environment by automatically extracting statements embedded in database objects, stored in application source code and binary fi...
Toad for Oracle – How to tell what columns would be good for indexes
Toad for Oracle – How to tell what columns would be good for indexes
Ever wonder how to tell what columns would be good for indexes? Once the index is created, ever wonder why you never see it in SQL explain plans you would expect to see it in??? There are 2 useful st...
How the Batch Optimizer Works
How the Batch Optimizer Works
This tip gives an overview on the functionality in the Batch Optimizer. Batch Optimizer Process The Batch Optimizer combines into one simple process the finding of SQL statements in your applicatio...
Why Run Times Vary
Why Run Times Vary
This tip covers why the run time of a SQL statement may vary from one execution to the next. When you execute a SQL statement several times in Quest SQL Optimizer, you may notice that the run time wi...
Understand the optimization process used in Quest SQL Optimizer
Understand the optimization process used in Quest SQL Optimizer
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...
Testing SQL Alternatives That Contain Variables
Testing SQL Alternatives That Contain Variables
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...
Testing SQL Alternatives in a Development Environment
Testing SQL Alternatives in a Development Environment
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...
Table Join Syntax
Table Join Syntax
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...
Rearranging the Driving Path
Rearranging the Driving Path
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...
Optimizing SQL statements with a VIEW
Optimizing SQL statements with a VIEW
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...
How to use the Batch Optimizer with Rule Based Optimizer
How to use the Batch Optimizer with Rule Based Optimizer
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...
Generating more SQL alternatives
Generating more SQL alternatives
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...