From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Segment partitioning

Segment partitioning - Oracle Database Tutorial

From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Start my 1-month free trial Buy for my team

Segment partitioning

“

- [Instructor] The natural life of a database is growth, but what happens when indexes are no longer enough to provide performance benefits or indexes aren't used as part of a query access? As the database grows table and index segments may benefit from partitioning, which breaks up data into smaller, more easily managed partitions and subpartitions. There are numerous types of partitioning to support query demands, including hybrid partitioning, which uses more than one column to partition on. Partitioning types such as interval, auto-list, range, list and hash partitioning are all common in Oracle databases. In Oracle 23c new combinations of partitioning types are supported for hybrid partition tables, such as single-level partitioning with interval, auto-list, range, and list partitioning. A partitioning strategy should be conducted carefully to ensure that both query execution and data processing is taken into consideration for benefits of the type of partitioning considered…

Contents