Hello,
Would the order of partition column in the where clause matter for performance? For eg: would there be any difference in performance in the below queries? select a from table where part_column = ‘y’ and non_part_column = ‘z’ or select a from table where non_part_column = ‘z’ and part_column = ‘y’ Also, how can I make sure that “partition pruning” is working as intended when checking the execution plan? Thanks in advance.
