Informix - Problem description
Problem IT30468 | Status: Closed |
QUERY RUN IN SPL IS MUCH SLOWER COMPARED TO QUERY RUN IN DBACCESS | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
A specific query run from a stored procedure takes much longer than the same query being run from dbaccess. The stored procedure takes 11.29 secs vs .05 sec when run from dbaccess. The stored procedure chooses to use a sequential scan while dbaccess uses an index for the same query | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC3. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC3. * **************************************************************** | |
Local Fix: | |
Use a query directive to specify using an index. | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix Server prior to 12.10.xC14 and 14.10.xC3. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to Informix Server 12.10.xC14 or 14.10.xC3. * **************************************************************** | |
Comment | |
Fixed in Informix Server 12.10.xC14 and 14.10.xC3. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 01.10.2019 25.02.2020 25.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC14, 14.10.xC3 | |
Problem solved according to the fixlist(s) of the following version(s) |