Tablespaces

A tablespace is a defined storage location for a database or database objects. Tablespaces are used by administrators to achieve the following:

• Maintenance: If the hard disk partition runs out of space where the database cluster is created and can't be extended, a tablespace on another partition can be created to solve this problem by moving the data to another location.
• Optimization: Heavily-accessed data could be stored in fast media, such as a solid-state drive (SSD). At the same time, tables that are not performance-critical could be stored on a slow disk.

The SQL statement to create a tablespace is CREATE TABLESPACE.