Skip Headers

# Schema Optimization

Previous

Next

Optimization is an important consideration when you design your database schema and object model. Most performance issues occur when the object model or database schema is too complex, which can make the database slow and difficult to query. This is most likely to happen if you derive your database schema directly from a complex object model.

To optimize performance, design the object model and database schema together. However, allow each model to be designed optimally: do not require a direct one-to-one correlation between the two.

This section includes the following schema optimization examples:

- Schema Case 1: Aggregation of Two Tables into One

- Schema Case 2: Splitting One Table Into Many

- Schema Case 3: Collapsed Hierarchy

- Schema Case 4: Choosing One out of Many

See Also

  Optimization
  Understanding Optimization