After EXPLAINing the following SQL query the filter table 'DSN_FILTER_TABLE' is populated with a compound predicate instead of a segregated one. Is this entry to the DSN_FILTER_TABLE is expected one?
SELECT * FROM DSN_PREDICAT_TABLE WHERE QUERYNO = PREDNO OR LEFT_HAND_SIDE = RIGHT_HAND_SIDE;
Here both individual predicates are Stage 2 predicates.
the query is written just as a sample.