Three or on table ?

  • Thread starter Thread starter Pietro
  • Start date Start date
P

Pietro

Hi,
I want to design a database with three tables,but actually they all have
the same and exact fields with the same formats,is it better to have them in
three tables or to combine them in one table only ?
 
Combine them into one table.

If appropriate, add one more field to distinguish whatever is the reason
they are currently in 3 tables. Then if you do need to select just the
records from one of the old tables, you can use a query to do that.
 
No. Provided you use the correct indexing, there would be no speed
degradation, even with millions of records in the table.
 
Every table should have a primary key index.

Index fields commonly used in searches or sorting. In table design, you
generally set the Indexed property of the field (lower pane of table design)
to:
Yes (Duplicates Ok)

In table design, you have an Indexes box for listing the indexes, setting
their properties, and defining multi-field indexes.

When you design your queries, craft them so Access can use the indexes.

More info:
http://support.microsoft.com/kb/209126
 
Back
Top