INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

A "SELECT .... FROM view_a INNER JOIN view_b ON view_a.col1 = 
view_a.col2" 
 
creates a temp table for the view which fills the temp dbspaces 
and takes much longer. 
 
A "SELECT .... FROM view_a, view_b WHERE view_a.col1 = 
view_a.col2" 
 
has a good query plan. 
 
INNER JOIN gets the same good queryplan with IFX_FOLDVIEW=0

**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of 12.10.xC1 through 12.10.xC4.                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A query with multiple view references may result in          * 
* unnecessary view materialization under the following         * 
* conditions:                                                  * 
*   - query references at least two views, and has no remote   * 
* references in query itself                                   * 
*   - both views are simple and have references to remote      * 
* table                                                        * 
*   - main query is in ANSI INNER JOIN format                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IDS-12.10.xC5                                      * 
****************************************************************

Problem Fixed In IDS-12.10.xC5

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

28.10.2014
16.10.2015
16.10.2015