A typical data mart houses huge amount of data which grows exponentially over time. The key challenges when dealing with such data include :
Database partitioning is a feature that supports distribution of data across database partitions by using a key-hashing algorithm.
This tutorial demonstrates the data partitioning technique and highlights the best practices to do the same. The need for creating data partitions and their advantages are analysed. A graph of the query execution time against the tables with data partitioning enabled is generated and the steps to create an explain snapshot displaying partition elimination during query processing are indicated.