ACCESS FEED: RE: [MS_AccessPros] Too many indexes.

Senin, 02 September 2013

RE: [MS_AccessPros] Too many indexes.

Andrew-

"Hidden" indexes are a result of defining Referential Integrity and should not be removed. Let's say you have an Orders and a Customers table with a Referential Integrity rule defined between CustomerID in Customers and CustomerID in Orders. If you've also defined a separate index on CustomerID in the Orders table via the Indexes window, that's a duplicate and can be removed. Also take a look at compound indexes - indexes on multiple fields. If you have separate indexes on each of the fields, you don't need the compound index.

Hope that helps...

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of adwsys
Sent: Monday, September 02, 2013 1:35 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Too many indexes.

Hi All, I've run into the "Too many indexes" problem on a couple of tables in one of my Access 2003 applications. I know that there are several duplicate indexes in the tables, but I'm not sure which ones I can safely delete. The hidden ones don't show up in the Indexes dialog anyway & have to be deleted programmatically, so does anyone have a copy of Allen Brownes CleanUpIndexes utility handy, or anything similar.

Thanks, Andrew

------------------------------------

Yahoo! Groups Links