Recent Tips and Tricks |
|
How to use the Batch Optimizer with Rule Based Optimizer |
| by Rene Woody |
| Learn about the way to determine how many SQL statements are executed in the Batch Optimzer when your database is using the Rule Based Optimizer. |
| Post Date: Monday, November 2, 2009 | View Details |
| |
|
|
How to select the criteria for terminating SQL alternatives |
| by Rene Woody |
| Learn about the options that you have for terminating SQL alternatives when testing for the best run time. |
| Post Date: Monday, October 19, 2009 | View Details |
| |
|
|
How to select the criteria for determining the "best SQL" |
| by Rene Woody |
| Learn about the two options that are available to determine which SQL statement is the best alternative for your application. |
| Post Date: Monday, October 05, 2009 | View Details |
| |
|
|
How to select best SQL to execute |
| by Rene Woody |
| Learn about the options that you can use to determine which SQL statements are executed to find the best run time. |
| Post Date: Monday, September 21, 2009 | View Details |
| |
|
|
How to minimize the effect of caching on run time |
| by Rene Woody |
| Learn about the options that you can select to minimize the effect of caching on the accuracy of the run time comparsions. |
| Post Date: Monday, September 7, 2009 | View Details |
| |
|
|
How to eliminate the effect of network traffic on the run time comparisons |
| by Rene Woody |
| Learn about the options that you can select for eliminating the effect of network traffic on the execution run times. |
| Post Date: Monday, August 24, 2009 | View Details |
| |
|
|
How to automate the Batch Optimizer process |
| by Rene Woody |
| Learn how to automate each of the three steps in the Batch Optimizer. |
| Post Date: Monday, August 10, 2009 | View Details |
| |
|
|
Understand how the Batch Optimizer works |
| by Rene Woody |
| Learn about the three steps that are performanced for you in the batch optimization process. |
| Post Date: Monday, July 27, 2009 | View Details |
| |
|
|
How to generate SQL aternatives without Oracle hints |
| by Rene Woody |
| Learn how to set the options so that no Oracle hints are used in the SQL alternatives. |
| Post Date: Monday, July 13, 2009 | View Details |
| |
|
|
How to shorten the time it takes to optimization a SQL statement |
| by Rene Woody |
| Learns some ways to shorten the amount of time it takes to optimize a SQL statement. |
| Post Date: Monday, June 29, 2009 | View Details |
| |
|
|
The order the SQL alteratives are displayed |
| by Rene Woody |
| Understand the order in which the SQL alternatives generated by the optimization process are displayed. |
| Post Date: Monday, June 15, 2009 | View Details |
| |
|
|
Understand why it is important to find the best "driving path" |
| by Rene Woody |
| Understand why it is important to find the best driving path when retrieving data. |
| Post Date: Monday, June 1, 2009 | View Details |
| |
|
|
Understand how Oracle optimization hints are applied in Quest SQL Optimizer |
| by Rene Woody |
| Learn how the Oracle optimization hints are applied to the SQL statements to generate more execution plans. |
| Post Date: Monday, May 18, 2009 | View Details |
| |
|
|
Select which table join syntax do you want to use |
| by Rene Woody |
| Learn how to generate SQL alternatives where the conditions for joining tables are specified in the WHERE clause or SQL alternatives using the Ansi-92 SQL standard which specifies tables joins with the INNER JOIN, CROSS JOIN, and OUTER JOIN with these joining conditions in the FROM clause. |
| Post Date: Monday, May 4, 2009 | View Details |
| |
|
|
How to optimize a SQL statement using a VIEW |
| by Rene Woody |
| Understand your options for generating SQL alternatives when your original SQL statement uses a VIEW instead of a TABLE. |
| Post Date: Monday, April 20, 2009 | View Details |
| |
|
|
How to generate more SQL alteratives |
| by Rene Woody |
| Learn how to generate more SQL alternatives during the optimization process. |
| Post Date: Monday, April 6, 2009 | View Details |
| |
|
|
How to generate fewer SQL alternatives |
| by Rene Woody |
| Learn how to generate fewer SQL alternatives during the optimization process. |
| Post Date: Monday, March 23, 2009 | View Details |
| |
|
|
Understand the optimization process used in Quest SQL Optimizer |
| by Rene Woody |
| Learn how the SQL optimization process in the Tuning Lab and the Batch Optimizer generates SQL alternatives. |
| Post Date: Monday, March 09, 2009 | View Details |
|
