My Assistant
![]()
Custom Search
|
![]() ![]() |
![]() |
![]() Post#1 | |
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? |
![]() Post#2 | |
![]() UtterAccess VIP Posts: 7,008 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) |
![]()
Custom Search
|
![]() | Search Top Lo-Fi | 11th December 2019 - 12:01 PM |