Indexes versus Relationship Index

  • Thread starter SteveW via AccessMonster.com
  • 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
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate Values in the index, primary key or relationship 4
Too Many Indexes Error 3
When to Index? 1
Limit for relationships from a field 2
Data Primary key vs. Artificial (Autonumber) primary key 78
Too many indexes? 6
Exceeds maximum index number 39
index when to add 4

Top