I have a 100,000+ record table with no delete() index and my speed of a SQL with "Where !delete()" is very quick, I really believe that it is not needed.

as always I am not the GURU but I don't see a dramatic improvement with the delete() index and a extra index (CDX) slows down the load of every index (CDX) cause all indexes (CDX) for a given table are stored in a single cdx i.e. table1.dbf, table1.cdx stores all indexes for table1.dbf


Hope this helps
Stephen McLaughlin
ssvalenteno@webab.com


>When I first started programming in VFP (about three years ago), I was told that I needed to have an index for each table on DELETED(). It was supposed to speed things up a bit.
>
>Recently, while reading several threads on the UT, I have found that some here say there should not be an index on DELETED() - that it actually slows things down?
>
>So, before I go back and take out all those indexes, I though I'd ask the question here to see what everyone thought. Should I have an index on DELETED() for every table or not?
>
>Thanks for your help!