Karen, In general, "narrow" tables with more rows and fewer columns are more efficient than "wide" tables. Certainly they are far more flexible for reporting, querying, and view design. As for storage space, you would have to test to be sure. Generally narrower table designs are also more space efficient, but I think that's a result of good normalization and elimination of redundancies, rather than just the mathematics of rowsize times rows.
Bill On Thu, 31 Oct 2002 11:18:32 -0500, tellef wrote: >For each piece of information I need to track, the table >would either have (all columns are integer): > 1 row in a table with 11 columns > 10 rows in a table with 3 columns > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
