|
|
 Blogs
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.
By e0aba78c-c04c-4ee1-a696-90b499bc5cc8 on
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 words “SQL Tuning”, you...
|
By StevenFeuersteinTW (User) on
Monday, April 27, 2009 8:47 AM
Every month, a Toad World newsletter goes out to thousands of Toad users and it includes a monthly puzzle that I write. Last month's puzzle went like this:
Which of the following blocks does not contain an infinite loop?
A.
DECLARE
l_line VARCHAR2(32767);
l_file UTL_FILE.file_type :=
UTL_FILE.fopen ('C:\temp', 'my_file.txt', 'R');
BEGIN
LOOP
UTL_FILE.get_line (l_file, l_line);
END LOOP;...
|
By StevenFeuersteinTW (User) on
Wednesday, April 22, 2009 6:06 PM
In case you simply can't get enough of Steven Feuerstein (no, I don't generally talk about my self in the third person or in the royal "we"), I invite you to check out this interview. I had an awful lot of fun answering the questions, and you might be entertained reading them.
|
By e0aba78c-c04c-4ee1-a696-90b499bc5cc8 on
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.
The SQL optimization process in the Tuning Lab generates multiple alternative SQL statements that...
|
By StevenFeuersteinTW (User) on
Monday, April 13, 2009 9:57 AM
It's truly one of the oddities of the PL/SQL language that it does not offer a delimited string parsing program. The closest we can get is DBMS_UTILITY.COMMA_TO_TABLE, and that is sadly deficient (it only parses comma-delimited strings and each item between the commas must be a valid PL/SQL identifier).
So I built one myself (the parse package) and put it in the demo.zip file...
|
By e0aba78c-c04c-4ee1-a696-90b499bc5cc8 on
Monday, April 13, 2009 2:18 AM
Written by Rene Woody
This blog is a continuation of a series about the SQL optimization process in the Batch Optimizer and the Tuning Lab modules of Quest SQL Optimizer for Oracle. It explains how to generate SQL alternatives that do not have Oracle optimization hints.
Oracle provides optimization hints that can be added to the syntax of a SQL statements to attempt to influence the execution plan that the database optimizer will use to execute the SQL statement. Quest SQL Optimizer for Oracle uses this technique in its optimization process to generate more unique execution plans for your original SQL statement. For more information on how the SQL alternatives are generated, see this previous blog: Optimizing SQL Part 1 – The Optimization Process. ...
|
By a33eae33-0bda-4a72-817d-7f62e5f5cdcc on
Wednesday, April 01, 2009
In this week’s blog, I’d like to introduce you to Toad’s Formatter. For those older “Toadies”, you’ll be familiar with its predecessor Formatter Plus.
|
|
|