I had a meeting with a developer today and we analyzed his table structure.
He was duplicating certain fields in the child table for "performance".
For example the parent (header table) had a Customer Name field and he would copy this Customer Name into every child (detail) record so he wouldn't have to look it up using a join?
Isn't this bad design?
Thanks for your opinion.
He was duplicating certain fields in the child table for "performance".
For example the parent (header table) had a Customer Name field and he would copy this Customer Name into every child (detail) record so he wouldn't have to look it up using a join?
Isn't this bad design?
Thanks for your opinion.