Avoid DB2 multi-index join in OnDemand?

Previous topic - Next topic

jfunk

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.