Horizontal Partitioning

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.

Get your copy of Information Governance World!

WordPress Image Lightbox
Scroll to Top