Indexes versus Relationship Index

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SteveW - 12 Apr 2005 11:28 GMT

I am after an opinion as to whether or not it is advisable or necessary to
index a field that is used in a relationship with a field on another table.
I do know that creating a relationship also creates an index, so is there
an advantage or disadvantage to creating a separate index for the fields?

Steve

Reply to this Message

Allen Browne - 12 Apr 2005 13:51 GMT

Access creates a hidden index on the foreign key in a relationship that is
created with referential integrity.

If you will create the relationship with enforced RI, there is no sense in
indexing the foreign key as well.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I am after an opinion as to whether or not it is advisable or necessary to
> index a field that is used in a relationship with a field on another
> table.
> I do know that creating a relationship also creates an index, so is there
> an advantage or disadvantage to creating a separate index for the fields?

Reply to this Message