It sounds like a simple warning/info message would be helpful when an index is created that includes a column in another index.
Regards, Alastair. From: Lawrence Lustig Sent: Thursday, November 01, 2012 3:28 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Indexing question << Thank you so much for that explanation, Larry! The guy who designed the table thought that "more is better" so I'm trying to pare down on an excessive number of indexes. >> I'm sure we've all seen the same thing. With a few tens of thousands of records it's not necessarily so bad, but when you get into the hundreds of thousands the effect on INSERT, UPDATE, and DELETE performance becomes very significant. Every column that needs an index should have one. And not one column more. -- Larry
