[TriLUG] OT: Opinion Poll: Database design
Matthew.Frye at rexhealth.com
Tue Jul 20 16:04:42 EDT 2004
> Brian Henning wrote:
> > Howdy Folks,
> > Just wondering what people's opinions are on the following topic:
> > a) One table with copious fields
> > -vs-
> > b) Multiple tables with fewer fields each, linked somehow
> If a single column of the table will be used as the search
> field, e.g.
> customer number, a single table is not such a bad idea. The
> column can
> be used as the index, and access will remain fairly efficient.
> If two or more columns will be used this way, it's a better
> idea to look
> for a logical way to divide the table so that the two tables can be
> indexed individually if possible.
It is for this specific reason that I prefer multiple tables. I like to at
least have the option of indexing different sets of data.
----- Confidentiality Notice -----
This e-mail and any attached documents contain confidential information belonging
to the sending entity, Rex Healthcare, and is intended only for the use of the
individual(s) or entity(s) associated with the recipient addresses listed in the message
header. The authorized recipient of this information is prohibited from disclosing this
information to any other party. If you are not the intended recipient, you are hereby
notified that any disclosure, copying, distribution or action taken in reliance on the
contents of the email and/or attachments is strictly prohibited. If you received this
e-mail transmission in error, please notify the sender immediately to arrange for return
or destruction of this information.
To report abuse or inappropriate use, please email abuse at rexhealth.com.
More information about the TriLUG