 |
Blogs
Toad and Database Commentaries |
Toad World blogs are a mix of insightful how-tos from Quest experts as well as their commentary on experiences with new database technologies.
 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 |
|
A Question from our Quest SQL Optimizer User |
|
RichardTo
|
Thursday, September 04, 2008 1:50 AM
|
|
|
Recently, we got a question from a customer:
“Why does adding a ||'' to the end of a key value improve performance... in this case significantly, this query runs in 187 milliseconds regularly where without the ||'' it takes minutes to run... This is the only modification in the result set from SQ ...
|
 |
|
Comments (2)
|
Read More...
|
|
|
|
A New Intelligent Test Run Function is under Research |
|
RichardTo
|
Friday, June 13, 2008 3:20 AM
|
|
|
|
A problem in the area of SQL optimization that has been around for a long time is the inaccuracy of the cost estimation of a SQL statement. A lot of people have the wrong conception that inaccurate cost estimations generated for a SQL statement by the database optimizer are caused by outdated statistics; whereas in fact, outdated or incorrect statistics is only one o ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
|
Batch Optimizer Part 4 – Options Settings for the Batch Optimizer |
|
RichardTo
|
Friday, May 09, 2008 5:53 AM
|
|
|
|
Written by Rene Woody
This blog is a continuation of a series about the Batch Optimizer in Quest SQL Optimizer for Oracle. It covers the execution options settings for determining the criteria for selecting the best alternative, for terminating longer running SQL, and eliminating the effect of caching on the comparison ru ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
|
|
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...
|
|
|
|
|
|
|
|
|
|
|