Informix - Problem description
Problem IT28479 | Status: Closed |
QUERY PLANS ON SP WITH TRIGGER REFERENCES DIFFER DEPENDING ON WHAT THE UPDATE STATISTICS WAS MADE | |
product: | |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 | |
Problem description: | |
The reproduction environment has the following call sequence Update on a table , the table has a trigger calling a SP with trigger references and in the SP a select was executed on the same tables as the trigger was invoked from. In case the SP called by the trigger runs with a query plan which was created from an Update statistics for base table the query in the SP is using the fast plan with an Index scan in case the SP called by the trigger runs with a query plan which was created by Update statistics for procedure the query in the SP is using a sequential scan. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IDS prior to 12.10.xC13. * **************************************************************** * PROBLEM DESCRIPTION: * * Query plans on SP with trigger references differ depending * * on what the update statistics was made. * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 17.03.2019 24.09.2019 24.09.2019 |
Problem solved at the following versions (IBM BugInfos) | |
12.10.xC13 | |
Problem solved according to the fixlist(s) of the following version(s) |