DB2 FOR LUW / DB2FORLUW / B10 - DB2

Suboptimal performance can be observe when running a query with
the following characteristics:

1. the query runs on columnized tables
2. the query contains an equality predicate and an inequality
predicate
3. the inequality predicate can be rewritten to containing only
constants and host variables based on the equality predicate

An example query:
select 1 from col_table where c19 and c1=:HV

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
****************************************************************

manually rewrite the inequality predicate. The example query can
be rewritten to:
select 1 from col_table, (select * from values(0) where :HV9)
where c1=:HV

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

26.11.2018
16.01.2020
16.01.2020