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

Insert Index into a Table 1
Duplicate Values in the index, primary key or relationship 4
Too Many Indexes Error 3
index when to add 4
Limit for relationships from a field 2
"Hexidecimal" Index 1
Page numbering with Merged Document and IF statements 1
Index Match & #values 0

Top