 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 |
|
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...
|
|
|
|
Dummy SQL Transformation Rules? |
|
RichardTo
|
Thursday, March 01, 2007 10:33 AM
|
|
|
|
I have been asked many times that why there are some dummy SQL transformations/rewrites that look meaningless, but it works in certain situations. Let me give you some examples that may help to explain what theory on behind of Quest SQL Optimizer.
|
|
Comments (0)
|
Read More...
|
|
|
Transformation Rules Relating to Index Usage |
|
RichardTo
|
Friday, February 09, 2007 8:25 AM
|
|
|
|
In Quest SQL Optimizer, transformation rules relating to index usage are designed to guide the database SQL optimizer as to how it should use the indexes for a specific SQL statement. Although those rules may familiar to most of SQL developers, but it is still worth to illustrate some commonly used rules for SQL beg ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
How to control many table join |
|
RichardTo
|
Wednesday, January 03, 2007 3:42 PM
|
|
|
|
In my last blog, I use two tables join to illustrate the simple path control, now let’s use a three table join SQL statement to demonstrate a more complicated scenario. Let’s assume that A.key, B.key and C.key are all indexed.
|
|
|
|
Comments (0)
|
Read More...
|
|
|
|
|
|
|
|
|
|
|