Informix - Problem description
Problem IT30036 | Status: Closed |
12.10 SERVER GENERATES SLOW ANSI JOIN QUERY PLAN COMPARING WITH 11.50 | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
12.10 server generates slow ANSI join query plan comparing with 11.50. Selectivity varies if distributions are present or not. Related to table reordering with ANSI JOINs. If SQL_FEAT_CTRL2 bit 0x4 DISABLE_LVL0_REORDER to disable idsdb00505160 is set then behavior resembles 11.50 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * 12.10 server generates slow ANSI join query plan compared to * * 11.50. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * 12.10 server generates slow ANSI join query plan compared to * * 11.50. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Comment | |
Fixed in IDS 12.10.xC13. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.08.2019 03.10.2019 03.10.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC13 | |
Problem solved according to the fixlist(s) of the following version(s) |