O'Reilly logo

Getting Started with SQL Server 2012 Cube Development by Simon Lidberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Partitioning cubes to speed up processing

As processing can be burdensome for the relational database, you often have to come up with ways that avoid reading all the information again and again from the sources. One option for avoiding this is the use of partitions. Just like in relational tables, partitions are a way to divide a large table into smaller chunks.

Imagine that you have a large fact table that contains all the order rows, every time that you process your measure group, you will read the entire table. This is probably not necessary as you do not change old order rows on orders that have been fulfilled. You will only add new order rows. If this is the case, then you can work with partitions. For this, you need to identify a good partition ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required