User spaces

The user data in the ORDERCUST database are distributed over the following three user spaces:

• The TABLESPACE space to store tables

• The INDEXSPACE space to store indexes

• The BLOBSPACE space to store BLOB objects

If tables and the associated indexes are created on separate spaces then the media recovery capabilities can be used in an efficient, differentiated way.

In the case of larger databases, you should create each table on a separate space in order to be able to control the access possibilities to the individual tables and to keep the down times due to recovery measures at a low level.

For more information on media recovery, see section “Media recovery”.