Chapter 7 Denormalizing a PDM
Note
Column denormalization uses the object replication feature, it is recommended to read the object replication chapter in the General Features Guide before using column denormalization
You can denormalize columns to eliminate frequent joins using column denormalization.
In this example, you want to have the division name printed on the pay slip of each employee, however, you do not want to create a join between those tables. You can denormalize columns in order to have column Div_Name in table PaySlip:
Column denormalization eliminates joins for many queries, however it requires more maintenance and disk space.
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |