>> But year_of_order or client_id should be in Orders only. There are cases
where it's right to denormalise and duplicate data, but the better
optimizers in modern RDBMS get, the less often there is a reasone for
this.
<<
Erland,
I think an Indexed view may be a good alternative to a denormaled
table, having the best of both worlds.