Horizontal partitioning divides a single logical table into multiple physical tables based on the rows. All columns generally appear in the new tables, but each new table contains a subset of the original table’s rows. The resultant tables may contain either discrete or overlapping subsets of the original table’s data. Horizontal partitioning is employed when there is a regular need to access or to isolate a readily identifiable subset of the “parent” table’s rows. This technique may be effective to meet security, distribution, and performance optimization needs.
