Creation of Multiple Partitions to improve Query and Load Performance

Practice Labs Module
Time
21 minutes
Difficulty
Intermediate

The "Creation of Multiple Partitions to improve Query and Load Performance" module provides you with the instructions and devices to develop hands on skills in the following topics: Creating multiple partitions to improve query performance, Updating partition's storage settings to improve load performance.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Overview

Introduction

The Creation of Multiple Partitions to improve Query and Load Performance module provides you with the instructions and devices to develop hands on skills in the following topics:

  • Creating multiple partitions to improve query performance
  • Updating partition's storage settings to improve load performance

Exercise 1 - Creating Multiple Partitions to Improve Query Performance

Partitions are a way of dividing a cube into one or more folders. These folders are usually placed on one or more hard drives. These are configured independently to increase performance.

Exercise 2 - Creating Multiple Partitions to Improve Load Performance

A partitioned cube can be loaded much more quickly than a non-partitioned cube, since multiple partitions can be loaded parallel to each other. Changing the storage setting and processing options of the partitions help to improve the load performance.

Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.