Splitting one large table into multiple physical units for management.
A technique that physically splits a table based on a criterion such as range or hash, making access to a specific range and maintenance more efficient. For example, if a table is partitioned by month, purging old data no longer means a slow row-by-row DELETE -- an entire month's partition can just be dropped as a unit, cutting the operation's time dramatically.
© 2026 ITBGM