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.