SQL Query Tuning

SQL Query Tuning

 

  

Hi all,

Does anyone have a very good example of SQL query tuning that I can have
a read on? That is, for example, one that starts with a very bad
performance result and how it was changed to work more efficiently ...
something elementary for dummies will be a good start. Thanks in advance
...

Cheers,


EDWIN ONG UY
\\|//
(o o)
^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^

"Choose a job you love, and you will never have to work a day in your
life." --Confucius
"How do I work? I grope." -- Albert Einstein
"Experience is the best teacher, enrolling in the class is the biggest
problem." -- Anonymous


DB2 & UDB email list listserv db2-l LazyDBA home page