Designing the Data Structure › Completing the Data Structure Design › Rearranging the Database Structure

Rearranging the Database Structure

Physical storage characteristics of the database can be adjusted for performance reasons.

The detailed reasons for changing these characteristics and the techniques for doing so are beyond the scope of this guide, but they might include:

• Moving tables between tablespaces
• Combining multiple indexes into a single indexspace
• Defining multiple databases
• Clustering a table around an index and partitioning tablespaces