Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   Table Performance Considerations >

Denormalizing the Data Model to Improve Performance

The entity-relationship data model that the IBM Informix: Guide to SQL Tutorial describes produces tables that contain no redundant or derived data. According to the tenets of relational database theory, these tables are well structured.

Sometimes, to meet extraordinary demands for high performance, you might have to modify the data model in ways that are undesirable from a theoretical standpoint. This section describes some modifications and their associated costs.

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]