Learnt something new in Oracle its about Split partition optimization. If all rows after split end up to a single partition and if you ...