Tablespace

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 cannot 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.