Data Warehousing: Horizontally Partitioning the Fact Table

April 4, 2008

[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








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers