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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only