OnDemand Users Group

Support Forums => CMOD for z/OS Server => Topic started by: jfunk on August 08, 2014, 02:11:36 PM

Title: Avoid DB2 multi-index join in OnDemand?
Post by: jfunk on August 08, 2014, 02:11:36 PM
Is there a way to avoid OnDemand building a DB2 query with multi-index query?

example: table ONE has indices
1. Idx1
   a. col1
   b. col2
2. Idx2
  a. col1
  b. col3

the WHERE clause contains
WHERE col1 = ? AND (col2 = ? or col3 = ?)
due to the customers selection criteria.
Within DB2, a UNION would be used.  Please advise if there is a way to avoid utlizing OnDemand.  Thank you.