|
|
|
|
|
|
by goto11
1130 days ago
|
|
|
> Normalisation at all costs is foolish - if the cost exceeds the value, then don't do it. Value of denormalization: May improve query performance for some particular use cases. (But probably not any more than using a materialized view) Cost of denormalization: Risk of anomalies (inconsistencies) which mean the database is not a reliable source of information anymore. Murphys law mean that this is basically bound to happen sooner or later. You should worry about this. Just use a view. |
|
|