Optimize for 1 Row as a Default BCA Madness?

Jorg Lueke

Optimize for 1 Row as a Default BCA Madness?
Why oh why would anyone make Optimize for 1 row a global parm? There's
nothing like getting a question about poor performance and seeing

OPTIMIZE FOR 1 ROW
FETCH FIRST 400 ROWS ONLY

With the clause 300+ seconds without 3 seconds. The underlying tablespace
has a fantastic rate if 1.13 getpages per sync/io.

_____________________________________________________________________

* IDUG North America * Tampa, Florida, * May 10-14 2010 * http://IDUG.ORG/NA *
_____________________________________________________________________

http://www.idug.org/db2-videos.html has hundreds of video presentations!
Did you miss out on attending an IDUG conference?
Many of the presentations were recorded and are available on our website!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's DB2-L