Back at you "Turkey Lover" - It looks like you don't have far to travel
to find a turkey to love... Is that part of your DBA job requirements
when interviewing - "Must be a gobbler of resources"?

:)


-----Original Message-----
From: John Kruger
[mailto:db2udbdba-ezmlmshield-x57034724.[Email address protected]
Sent: Wednesday, November 22, 2006 11:47 AM
To: LazyDBA Discussion
Subject: Default query optimization class (DFT_QUERYOPT) = 0


Greetings Turkey Lovers,

I have a question and I have my own strong opinion.

An individual has set the database SQL Optimization level to Zero
because his six SQL statements run faster that way.

I've asked this person to explicitly set the SQL optimization level for
each of his SQL statements instead of making the entire database suffer
as well.

At the same time we have heavy real-time replication running poorly so
the default Zero optimization level touches all, not just his six SQL
statements.

How many of you have a database query optimization set at Zero? How
many of you set the SQL optimization level explicitly for individual SQL
statements?

Please talk amongst yourselves and all comments are appreaciated.

Life in the slow lane at the Sunshine Retirment Center.
Happy Thanksgiving to All














---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


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