Indexes on the object type tables in the RDBMS enhance the performance of repository queries. When a repository is configured, the Content Server creates various object type indexes. There are several administration methods for managing type indexes:
MAKE_INDEX
Creates type indexes for special requirements. For more information about the MAKE_INDEX method, refer to MAKE_INDEX.
MOVE_INDEX
By default, type tables and indexes are stored in the same tablespace or segment. However, you can create a repository with separate tablespaces or segments for each or you can move the indexes later, using the MOVE_INDEX method. Indexes that you create can be placed in any directory. For more information about the MOVE_INDEX method, refer to MOVE_INDEX.
For more information about creating a repository with separate tablespaces, refer to the EMC Documentum Content Server Installation Guide.
DROP_INDEX
Removes a user-defined index. It is strongly recommended to not remove any of the system-defined indexes. For more information about the DROP_INDEX method, refer to DROP_INDEX.