May 2024
Intermediate to advanced
750 pages
12h 29m
English
In this chapter, we will discuss tablespace and partitioning. Partitioning divides a large dataset into smaller manageable subsets, usually called partitions. Partitions can be stored, managed, and accessed separately, improving the database's scalability, availability, and performance.
Before partitioning, there is guidance on physical data storage once we have the concept of tablespaces, which are logical representations ...