Data Warehousing: Horizontally Partitioning the Fact Table

Friday Apr 4th 2008 by 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

Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved