 |
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. Have some views of your own to share? Post your comments! Note: Comments are restricted to registered Toad World users.
 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 |
 |
|
Richard To is chief technologist, APM solution, at Quest, He is the designer of Quest SQL Tuning products with over 15 years of SQL tuning technology research experience in Oracle, DB2, Sybase and SQL Server, Richard also specializes in using AI technique to solve database performance problems.
Rene Woody through many years of experience in the computer industry has gained a varied background in applications and systems programming, databases, classroom training, documentation, post and pre-sales technical support. She is currently a Technical Writer for the Quest SQL Optimization products. She has a degree in Systems Development.
Richard and Rene's blog helps solve problems in your SQL code, tune queries, and shares new tips, tricks, and techniques on SQL tuning.
Recent postings on SQL tuning: |
|
|
|
Executing SQL In Tuning Lab – Part 5 – Selecting Alternatives to Test |
|
RichardTo
|
Friday, June 12, 2009 5:27 AM
|
|
|
|
In Quest SQL Optimizer when you generate alternative SQL statements for your original SQL statement you may be presented with hundreds of SQL alternatives. The only way to be completely sure that you have the fastest one is to run all the SQL alternatives. But unless the SQL statements run relatively quickly, this is not always practical. So then you are left to determine which SQL statements you should select to test.
|
 |
|
|
Read More...
|
|
|
|
|
|
10 Common Misconceptions in SQL Tuning #2 |
|
RichardTo
|
Tuesday, April 28, 2009 8:50 AM
|
|
|
|
This blog is the second in a series about common misconceptions surrounding SQL tuning. It covers the misconception that the goal of SQL tuning is to write a better SQL statement. The real goal of SQL tuning is not to create a better SQL statement, but it is to help the database optimizer to make the right decision when it is choosing the execution plan.
If you browse the internet with the key ...
|
|
|
|
|
Read More...
|
|
|
Executing SQL in Tuning Lab – Part 1 – Criteria for Terminating SQL |
|
RichardTo
|
Friday, April 17, 2009 2:37 AM
|
|
|
|
Written by Rene Woody
This blog is the first of a series about test running the SQL statements in the Tuning Lab in Quest SQL Optimizer for Oracle to find the best performing SQL statement in your database environment. It covers the options for terminating the SQL alternatives when they are executed in a batch.
|
|
|
|
|
Read More...
|
|
|
|
10 Common Misconceptions in SQL Tuning #1 |
|
RichardTo
|
Friday, March 13, 2009 4:11 AM
|
|
|
|
This blog is the first in a series about misconceptions surrounding SQL tuning that are quite common. The first one covers the misconception that you can use the estimated cost from the database SQL optimizer to accurately judge the performance of a SQL statement in comparison to its rewrites.
SQL tuning is a very interesting topic and most DBA or devel ...
|
|
|
|
|
Read More...
|
|
|
|
|
|
|
|
How to use Quest SQL Optimizer to Tune Complex SQL - A Real Life Example #1 |
|
RichardTo
|
Friday, December 19, 2008 12:16 PM
|
|
|
|
Recently, I received an email from the presales support team. They asked me to help them tune three SQL statements for a benchmark database provided by a customer. Our presales support said that our SQL Optimizer was not providing any alternatives for two of these three complex SQL statements. I found two of these SQL statements were very complicated and I knew that there should be a lot of alternative SQL genera ...
|
|
|
|
|
Read More...
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|