more records or more fields

T

turkey

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?
--
 
K

Kevin3NF

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
 
Top