IC71158: LEFT OUTER JOIN TO A REMOTE TABLE IS FASTER WHEN IT DOES NOT USETHE INDEX ON THE REMOTE TABLE

APAR status

• Closed as program error.

Error description

• You have a left outer join between a local and remote table. The
  query uses the index on the remote table. You remove some of the
  distributions (update statistics) from columns on the local
  table involved in the join. The query does a sequential scan of
  the remote table and runs faster.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of an ansi outer join                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * An ansi outer join might pick up slow plan when outer join   *
  * size is not estimated accurately.                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to 11.50.xC8 when available.                         *
  ****************************************************************
  

Problem conclusion

• Fixed in 11.50.xC8.
  

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

• RB15 PSY

     UP