IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50

The sql explain feature EXPLAIN_STAT, when enabled, fails to 
capture query times in the sqexplain.out file if the query 
contains an union. 
 
Example of sqexplain.out for query with a union: 
 
  type     rows_sort  est_rows  rows_cons  time 
  ------------------------------------------------- 
  sort     0          329       0          00:00.00 
 
  type     table  rows_prod  est_rows  rows_scan  time 
est_cost 
 
---------------------------------------------------------------- 
--- 
  scan     t47    25         1         25         00:00.00 
4615

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of 11.10 and 11.50 when explain is on and query        * 
* involves system-generated temporary tables                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* When explain is on (and EXPLAIN_STAT onconfig parameter is   * 
* 1, which is the default setting), and a query uses a         * 
* temporary table (for materialization of a view or derived    * 
* table, for temporary index in an AUTO INDEX path), then      * 
* query statistics on the temporary table is not properly      * 
* printed out in the "Query Statistics" section of the explain * 
* file.                                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to IDS 11.50.xC5 and above.                          * 
****************************************************************

The problem was first fixed in IDS 11.50.xC5. Query statistics 
on temporary table/index is now properly printed in explain 
file.

not known / see Local fix

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

01.05.2009
11.01.2010
11.01.2010

11.50.xC5