Creating relationships

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

Which is more efficient, creating relationships at the table level using
Tools->Relationships or creating the relationships between tables when I
create a query?
Thanks
Tony
 
On Tue, 23 Oct 2007 13:37:49 +0100, "Tony Williams" <[email protected]>
wrote:

The former is the only way to ENFORCE such relationships, which is
essential for a well-behaving database.

-Tom.
 
If you create the relationship for all tables, then you create a query the
tables in the query will be correctly linked. This reduces to possibility of
incorrect linking at the query level. I'm doubt there is any speed difference
between the two when running the query as the SQL created would be the same.

James
 
On Tue, 23 Oct 2007 05:50:01 -0700, JamesDeckert

Actually there would be a speed difference. If the relationships are
created in the Relationship window and enforced, Access will create
semi-hidden indexes behind the scenes.
If you just create a query and draw a line between two tables, I bet
you the same does not happen.
Indexed queries are faster than non-indexed ones.

-Tom.
 
Back
Top