Indexes versus Relationship Index

  • Thread starter Thread starter SteveW via AccessMonster.com
  • Start date Start date
S

SteveW via AccessMonster.com

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
 
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.
 
Back
Top