X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Duplicate Index Created By Relationship, Access 2016    
post Aug 10 2019, 05:13 AM

Posts: 23
Joined: 7-May 17

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?
Go to the top of the page
post Aug 10 2019, 06:07 AM

UtterAccess VIP
Posts: 7,066
Joined: 30-June 11

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.

Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc

All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    25th January 2020 - 08:26 AM