IC63943: QUERY WITH SUBQUERY FILTER UNDER OR CLAUSE RUNS SLOWLY

APAR status

• Closed as program error.

Error description

• A query with OR clause as predicates, where one arm of the OR
  clause has an AND clause where one side of the AND is a simple
  predicate and the other side of the AND is a subquery
  predicate, may have sub-optimal query plan and poor query
  performance.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users with query involving OR clauses.                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * A query with OR clause as predicates, where one arm of the   *
  * OR clause has an AND clause where one side of the AND is a   *
  * simple predicate and the other side of the AND is a subquery *
  * predicate, may have sub-optimal query plan and poor query    *
  * performance.                                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDS 11.50.xC6 and above.                          *
  ****************************************************************
  

Problem conclusion

• The problem is fixed in IDS 11.50.xC6.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSN

     UP