Too add a new table or not

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 Mon Nov 05 2001 - 22:53:24 CST