DB2 FOR LUW / DB2FORLUW / 970 - DB2

The optimizer will consider an optimization for an SQL statement 
containing a MIN or MAX aggregation without a group by clause, 
referred to as a one-fetch group by operation, if the stream is 
ordered on the aggregation source column. You can identify if 
the group by operation is optimized as a one-fetch by collecting 
an EXPLAIN of the statement and searching for the ONEFETCH 
argument in the group by operator details: 
 
                ONEFETCH: (One Fetch flag) 
                        TRUE 
 
If the input cardinality is significantly underestimated to 
value of 1 or less, then the optimizer might not choose to 
perform this optimization, and the ONEFETCH argument will not 
exist in the formatted EXPLAIN output.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V97 FP9                                       * 
****************************************************************

In most cases, collecting up-to-date statistics will improve the 
cardinality estimate if the SQL statement contains predicates 
that qualify the latest data in the table and the statistics are 
stale.

DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 V97 FP9

In most cases, collecting up-to-date statistics will improve the 
cardinality estimate if the SQL statement contains predicates 
that qualify the latest data in the table and the statistics are 
stale.

forerunner  : APAR is sysrouted TO one or more of the following: IC96658 IC96826 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

21.11.2012
14.02.2014
14.02.2014

9.7.FP9