Designing the Data Structure › How to Complete the Data Structure Design › Rearrange the Database Structure

Rearrange 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