Thank you Michael and Nikolay for another interesting episode. Only through your explanation I realized that partition elimination cannot happen for prepared statements during the planning phase when query parameters are involved in the pruning operation. This seems trivial in hindsight, but valueable to remember. I think no RDBMS can work around that barrier.
Thank you Michael and Nikolay for another interesting episode. Only through your explanation I realized that partition elimination cannot happen for prepared statements during the planning phase when query parameters are involved in the pruning operation. This seems trivial in hindsight, but valueable to remember. I think no RDBMS can work around that barrier.
+1 to your VERBOSE proposal Michael