Horizontal Partitioning

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.

[Category=Information Management ]

Source: Information-Management.com, 22 June 2010 08:26:17, www.information-management.com/glossary/f.html