 Do you have a topic that you'd like discussed? We'd love to hear from you. Send us your idea for a blog topic.
|
|
|
|
|
|
|
Author: |
RichardTo |
Created: |
Monday, October 30, 2006 2:28 PM |
 |
|
Solving problems in your SQL code, tune queries, and share new tips, tricks, and techniques |
|
Batch Optimizer Part 1 – How the Batch Optimizer Works |
|
RichardTo
|
Friday, March 28, 2008 4:01 AM
|
|
|
|
Written by Rene Woody
We all know that it is important to create SQL statements that perform well in our database environment, but all too often, after creating a SQL statement that retrieves the correct results, the optimizing of the SQL statement is left for another time. Frequently, that time never arrives. Quest SQL ...
|
 |
|
Comments (0)
|
Read More...
|
|
|
How to use the Quest SQL Optimizer |
|
RichardTo
|
Tuesday, March 18, 2008 5:31 AM
|
|
|
|
Written by Rene Woody
Quest SQL Optimizer can do an extensive transformation of the syntax of a SQL statement while still maintaining the exact same result set. This exhaustive transformation can produce hundreds of SQL alternatives. So it is necessary to have some insight as how to find a SQL alternative that is better than your ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
What about a Self-learning SQL Optimizer? |
|
RichardTo
|
Tuesday, October 09, 2007 4:45 AM
|
|
|
|
There are at least two database vendors are trying to build self-learning SQL optimizers. The idea is to use actual statistics from executed SQL statements to rectify the future cost estimation of the same or similar SQL statements. It seems like a good idea, but, you will find that their existing self-learning ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
A SQL Performance History from AWR |
|
RichardTo
|
Thursday, September 13, 2007 2:51 PM
|
|
|
|
I have been working on SQL Tuning research for more than 10 years, but my focus has changed to time-series forecast technology in the last two years. Recently, Oracle’s AWR and other database vendor’s statistics/metrics repository have drawn my attention. The relatively low cost of keeping performance statistics in databases, combined wi ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
How Quest SQL Optimizer works with Hints |
|
RichardTo
|
Tuesday, August 14, 2007 10:28 AM
|
|
|
|
Today database vendors are more willing to provide a means for the end user to influence the decision of which execution plan to use for a SQL statement. They provide this because database optimizers cannot guarantee that they the will generate the best execution plan for a given SQL statement. However, when you do apply Optimization Hints you ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
|
|
|
Quest Recursive SQL Transformation Technology |
|
RichardTo
|
Wednesday, June 20, 2007 4:58 AM
|
|
|
|
Quest Recursive SQL Transformation technology is an innovative AI technology that simulates human SQL transformation technique. It incorporates a set of transformation rules to transform SQL statements on a section-by-section basis. This replaces the trial and error method used by human to rewrite the syntax of a SQL statement. Each t ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
From SQL Optimization Hints to Plan Instructions |
|
RichardTo
|
Wednesday, May 02, 2007 7:05 AM
|
|
|
|
Most database vendors provide optimization hints which enable a user to influence the decision the database SQL optimizer will make when determining which execution plan it will choose. Oracle provides a full set of optimization hints to help users to rectify an i ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
|
|
|
|
|
|
|
|