Toad World Blogs - Richard To's Blog

Blogger List

	Johannes Ahrends Toad and Oracle
	Ben Boise Toad SC Discussions
	Kevin Dalton Benchmark Factory
	Steven Feuerstein PL/SQL Obsession
	Devin Gallagher Toad SC discussions
	Stuart Hodgins JProbe Discussions
	Henrik "Mauritz" Johnson Toad Tips & Tricks on the "other" Toads
	Mark Kurtz Toad SC discussions
	Michael Lumbard Toad SC discussions
	Daniel Norwood Toad for Data Analysts, Toad Extension for Visual Studio
	Debbie Peabody Toad for Data Analysts
	Gary Piper Toad Reports Manager
	John Pocknell Toad for Oracle, JProbe
	Kuljit Sangha Toad SC discussions
	Bert Scalzo Toad for Oracle, Data Modeling, Benchmarking
	Jeff Smith Toad product family
	Richard To SQL Optimization
	Jim Wankowski DB2 - LUW and z/OS
	John Weathington
	Toad Data Modeler Data Modeling
	Real Automated Code Testing for Oracle Quest Code Tester blog

Blog Categories

Benchmark Factory (9)

Code Tester for Oracle (24)

JProbe (5)

PL/SQL Obsession (40)

Quest SQL Optimizer (29)

Spotlight on Oracle (4)

SQL Navigator (2)

Toad Data Modeler (10)

Toad Ext for Visual Studio (7)

Toad for Cloud Databases (0)

Toad for Data Analysts (28)

Toad for IBM DB2 (15)

Toad for MySQL (3)

Toad for Oracle (125)

Toad for SQL Server (9)

Blog Tags

toad for oracle (122)
oracle (62)
plsql (46)
sql optimization (37)
toad for data analysts (28)
code tester (19)
toad for ibm db2 (13)
automation (11)
batch optimizer (10)
virtualization (10)
schema browser (9)
toad for sql server (9)
data grid (8)
sql (8)
sql editor (8)
toad data modeler (8)
benchmark factory (7)
excel (7)
query builder (7)
report manager (7)
toad extension (7)
visual studio (7)
11g (6)
configuration (6)
freeware (6)
health check (6)
vmware (6)
connect (5)
dba module (5)
er diagrammer (5)
F4 (5)
linux (5)
refactoring (5)
spotlight (5)
unicode (5)
compare (4)
debugger (4)
export (4)
formatter (4)
make code (4)
rman (4)
strip code (4)
benchmark (3)
bfscript (3)
bulk collect (3)
code templates (3)
code xpert (3)
database browser (3)
db2 (3)
notebook (3)
oem (3)
RAC (3)
session browser (3)
speed (3)
sql optimizer (3)
toad for mysql (3)
tpc-c (3)
9.7 (2)
alert log (2)
app designer (2)
awr (2)
code insight (2)
code snippets (2)
collection (2)
compare and sync (2)
compliance (2)
data generator (2)
data warehouse (2)
database explorer (2)
database monitor (2)
explain (2)
forall (2)
ftp (2)
group execute (2)
handbook (2)
installation (2)
job scheduler (2)
multi-task (2)
nested table (2)
os command (2)
profiler (2)
recovery (2)
release history (2)
save as (2)
schema compare (2)
sql recall (2)
stats pack (2)
subversion (2)
team coding (2)
trace file browser (2)
while loop (2)
10g (1)
64 bit (1)
7zip (1)
action (1)
addm (1)
alter (1)
ansi join (1)
array (1)
ccleaner (1)
code coverage (1)
code road map (1)
CRON (1)
cursor for loop (1)
data browser (1)
data subset (1)
database probe (1)
dbms_flashback (1)
dbms_profiler (1)
ddl (1)
feuerstein (1)
filezilla (1)
flash drive (1)
flow control (1)
for loop (1)
group policy manager (1)
hints (1)
import (1)
index (1)
inheritance (1)
invoker rights (1)
ipad (1)
java (1)
latency (1)
log switch (1)
logical model (1)
ltrim (1)
master-detail browser (1)
monitor (1)
multi-select (1)
naming standards (1)
network (1)
object explorer (1)
OEBS (1)
package (1)
parser (1)
partitioning (1)
performance (1)
pragma (1)
project manager (1)
RAT (1)
revo (1)
REXEC (1)
schema report (1)
script manager (1)
search (1)
set operator (1)
sga (1)
slow (1)
sonarsource (1)
source control (1)
space projection (1)
sql monitor (1)
sql navigator (1)
sql script (1)
sql tracker (1)
sql*plus (1)
standards (1)
statistics (1)
stored procedure (1)
string parser (1)
sub-model (1)
sub-type (1)
synch (1)
synchback (1)
TELNET (1)
toad (1)
trace (1)
unit test (1)
unix (1)
usb (1)
utility (1)
v10 (1)
v9.5 (1)
version control (1)
waits (1)
workload replay (1)
workspace (1)
xml (1)

WELCOME, GUEST

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:

Richard To

Created:

Monday, October 30, 2006 2:28 PM

Richard To is chief technologist and designer of Quest SQL Tuning products. Richard specializes in using AI technique to solve database performance problems.

Richard'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:

Why SQL Tuning?

By Richard To on Monday, October 30, 2006 2:28 PM

For years, commercial database manufacturers have fought an endless battle to improve the performance of inserting, updating, deleting, and retrieving information stored in the database. Despite their continual efforts and hard work, we have not seen a significant improvement in the performance of most Relational Database Management Systems (RDBMS). Users still suffer from under-performing SQL statements and database experts...

PermaLink Read More »