Ronald,

>Our conclusion was to keep the DELTED() indexs and add the NOFILTER clause

We use a similar construct: our indices are iif(deleted(), 1, 0)

This stops VFP from using the index automatically, and we can add the use of this index
by specific for and where clauses. This way Rushmore can do it's usually beneficial work.

Only if you are using bulk copy or batch inserts the
added work for creating the index can be felt.

Be sure to check out vfp9's binary indices for your app seems fitting.

my 0.02 EUR

thomas