more records or more fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is it more efficient to have more records and less fields or less records and
more fields which may be blank most of the time?
--
 
Generally speaking, records are cheap, fields are expensive.

More records and less fields.

This assumes we are aiming for normalized design and that the fields in
question can be logically broken out into other related tables. Sometimes
more fields is the proper way to go.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

acnewrec? 1
Setting Record Order in Report 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Check length for each record for a delimited file 4
Access IIF Statement - If field is greater than other field by =/-percentage 0
Conditional Formatting 3
Query duplicates results due to many-to-many relationships 5
Bloating 2

Back
Top