January 21, 2004 01:21 PM
Cube-Partitioning Tests
Rating:

(0)
SQL Server Magazine
InstantDoc ID #41231
To figure out which partition designs work best to reduce the number of sequential scans for Listing 2 and Listing 3 in the main article, I created six cubes, structured identically but with different partition designs. The idea is to partition along the Time and Occupant_Severity dimension members (which Figure 2 in the main article shows) that the queries in Listing 2 and Listing 3 are looking for so that they can get to those members directly without a scan. To create a new partition, you can...
...This article is for paid Professional Members only.
Already a Professional Member? Please log in now: