Data Warehousing: Horizontally Partitioning the Fact Table

Friday Apr 4th 2008 by DatabaseJournal.com Staff

Manage large tables by dividing them into discreet, non-overlapping sections.

[From SQL Server Magazine]

A horizontally partitioned fact table’s rows are divided into discreet, non-overlapping sections. These sections are defined by a range of values in the FOR VALUES clause. To horizontally partition a fact table you need to create a partition function, a partition scheme, and a partitioned table.

The article continues at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=98007

Mobile Site | Full Site