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 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...
Inspect SGA retrieves executed SQL statements from Oracle’s System Global Area or currently running SQL statements from Oracle’s open cursor. Once you retrieve the statements, Inspect SGA displays the...
Using SQL Rewrite mode in Optimize SQL consists of two steps. In the first step, SQL Optimizer generates semantically equivalent alternatives with unique execution plans for your original SQL statemen...
You can analyze the impact of new indexes on your SQL statement's execution plans before you physically create the indexes on your database. You can create indexes in Optimize SQL or Optimize Indexes ...
Outline Management displays stored outlines deployed using SQL Rewrite mode in Optimize SQL. To manage outlines Select the Manage Plans tab in the main window. Tip: Select the Show Manage Plans che...
You can use Best Practices to analyze your SQL statement and database to recommend common techniques for improving database performance. Since the recommendations can also affect performance of other ...
SQL Optimizer identifies columns to use as index alternatives for a SQL statement after it analyzes SQL syntax, relationships between tables, and selectivity of data. SQL Optimizer then combines ident...
The Deploy Outline function in Optimize SQL improves SQL statement performance without changing your original source code. Using Optimize SQL, you can generate SQL statements that are semantically equ...
To batch optimize SQL Select the Batch Optimize tab in the main window. Click Add Code to Optimize in the Batch Job List pane and select All Types. The Add Batch Optimize Jobs window displays. ...
