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













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