DB2 EXPLAIN TABLES

Venkata Sai Arjun Pettam

DB2 EXPLAIN TABLES

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?

 

SQL Query:

 

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.