PL/SQL Optimization: Table Partitions

Partitions

In PL/SQL, using a PARTITION is a way to split a large table into smaller segments. Each partition is known by its specific name and has its own characteristics such as its storage and index. Watching this video, in just over 15 minutes, you will learn how to use this mechanism in PL/SQL.

4.3k, Aug 22 2019

Artur M

Using a partition allows you to divide a large table into smaller portions. This allows us to speed up the execution of many queries. And this is what this lesson will be about.