You’ve probably heard sayings like “sometimes things aren’t always what they seem” and “people lie”. Well, sometimes execution plans lie. It’s not really by intent, but it is sometimes difficult (or impossible) to represent everything in a query execution tree in nice tabular format like dbms_xplan gives. One of the optimizations that was introduced...
The other day I was reading the 11g Database VLDB and Partitioning Guide and came across the below execution plan for a partial partition-wise join between sales and customers. --------------------------------------------------------------------------- | Id | Operation | Name | Pstart| Pstop | --------------------------------------------------------------------------- | 0 | SELECT STATEMENT | | | | | 1 | PX...