By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,062 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,062 IT Pros & Developers. It's quick & easy.

Is there any advantage to defining relationships for tables and queries

P: n/a
In general will I see any query performance gains?

More of a DB2 guy myself.

Regards

Phil
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
For JET dbs, the Relationships window sets up the Foreign Key
relationships between tables.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

runners4bush wrote:
In general will I see any query performance gains?

More of a DB2 guy myself.


Nov 13 '05 #2

P: n/a
On 16 Sep 2004 08:31:00 -0700, ru**************@gmail.com
(runners4bush) wrote:
In general will I see any query performance gains?
More of a DB2 guy myself.
Regards
Phil


Hi Phil
Relationships as such are for data integrity and consistency (good
things to have!), adding them CAN make performance slower, eg when new
records are added or deleted. . They are not necessary in read-only
databases.

HOWEVER

After design, performance depends mainly on having the right indexes.
Access routinely creates indexes based on the relationships you
define, so if you skip the relationships you will need to check that
you have set up indexes yourself where appropriate, eg on commonly
joined fields

On balance I suggest you set up all applicable relationships.

David
David
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.