Partitioning is the database process where large tables are divided into multiple smaller partitions. The main objective of the partitioning is to aid in the maintenance of huge tables and to reduce the overall response time to load bulk data into tables. Partitioning a table helps improving read query performance, however not all read queries may are optimized. This lab is divided into three exercises. In the first exercise, we will learn about creating partition. In the second exercise we will learn about managing partitions and in the third exercise, we’ll talk about scenarios where partitioning is helpful in optimizing read queries.
Exercise 1: Creating Partition
Exercise 2: Optimizing query performance using partitioning
Exercise 3: Managing Partitions