Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Tables + Relationships _ Duplicate Index Created By Relationship

Posted by: allen_edgar Aug 10 2019, 05:13 AM

When I loop thru a Tabledef.Indexes collection, I note that there are often more indexes than are listed in the table design indexes dialog. This is because I specifically included indexes when I built the table not realizing that Access will create another identical index if I later create a relation to another table that includes the same field name.

My question is: Should I remove the original index I created in table design view so that Access is not updating two identical indexes every time a new record is added? I guess this is a performance issue. Am I missing something?

Posted by: DanielPineault Aug 10 2019, 06:07 AM

Either way. It truly is up to you.If you truly want to optimize things then yes, you can delete the duplicates, but then you'll need to get into the habit of doing this for all your table and any new ones down the road. Normally, I wouldn't waste my time worrying about this unless you're having issues with hitting the limit of allowed database indexes.