Oracle DB Partitioning features overview overview of partitions

Overview: In an Oracle database, partitioning (partitioning) allows very large tables (table) or indexes (index) to be decomposed into small manageable blocks (pieces). These blocks are called partitions (partitions). Each partition must have the same logical structure, such as column names, data types, constraints, and so on, but each partition can have its own independent physical structure.

Benefits of Partitioning:

1. Increase the availability of:

2. Easy management of Mode objects

3. Reduce contention for resources in OLTP systems

4. Improve the performance of queries in the Data Warehouse

Partition key (Partition key)

A partition key is one or more columns that are used to determine which partition each row goes to.

Partitioning policy:

1. Range partitioning (range Partition)

such as partitioning by date.

2. List partition (Partition)

Used when partitioning a column value that is discrete.

3. Hash partition (hash Partition)

Feature: By using the built-in hash function, the rows are evenly distributed across each partition, bringing the number of rows per partition to a balanced level.

Oracle DB Partitioning features overview overview of partitions