It is easier to manage very large databases if you partition them into separately managed parts called table spaces.
A table space lets you assign the location of data to particular logical devices or portions thereof. For example, when creating a table you can specify that its indexes or its long columns with long or large object (LOB) data be kept away from the rest of the table data.
A table space can be spread over one or more physical storage devices (containers) for increased performance. However, it is recommended that all the devices or containers within a table space have similar performance characteristics.
A table space can be managed in two different ways: as a system-managed space (SMS) or as a database-managed space (DMS).
[ Top of Page | Table of Contents | Glossary | Index ]