Three or on table ?

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

 

[Allen Browne]

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.

 

[Pietro]

Well,this is what i prefer,but won't this make the database run slowly?

 

[Allen Browne]

No. Provided you use the correct indexing, there would be no speed
degradation, even with millions of records in the table.

 

[Pietro]

I want to know more about this :"correct indexing"

 

[Allen Browne]

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

 

[conchalafuente]

Me gustaria escribirme al grupo de noticias pero en español.

 

[conchalafuente]

Me gustaria escribirme al grupo de noticias pero en español.