One possibility
lh, February 19, 2018 - 11:21 am UTC
Hi
I have seen few cases where partition pruning is not pushed into base tables of union. This can happen when partitioning column is not directly referenced in where clause.
If there does not exists union (only one table is referenced)
some magic, like bloom filters etc is happening and partitioning is used.