Informix - Problem description
Problem IT05226 | Status: Closed |
INNER JOIN ON A VIEW ON A REMOTE TABLE AND IFX_FOLDVIEW=1 CREATES A TEMP TABLE FOR THE VIEW | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
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 | |
Problem Summary: | |
**************************************************************** * 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 * **************************************************************** | |
Local Fix: | |
Solution | |
Problem Fixed In IDS-12.10.xC5 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.10.2014 16.10.2015 16.10.2015 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
12.10.xC5 | |
12.10.xC5.W1 |