Too add a new table or not

From: Pavs <pavle_sturma_at_hotmail.com>
Date: 5 Nov 2001 20:53:24 -0800
Message-ID: <692c44aa.0111052053.2bddc0ac_at_posting.google.com>

I was wondering what the rule is when it comes to adding a new table to a data structure as oppossed to sticking with existing tables and shoving all the new attributes in the existing tables. (Assume that the data remains normalised)

My boss with way more experience then myself argues that more can be done with less. "Why subject the database engine to more hits across multiple tables when you can stick to the one table" he says.

Well whats the rule? Received on Tue Nov 06 2001 - 05:53:24 CET