[X]My Assistant

[allen_edgar]

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?

[DanielPineault]

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.