Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is it reasonable to have index on DELETED()?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00196021
Message ID:
00200286
Views:
19
>What do you base that on? I've seen HUGE improvements in query performance achieved by adding a tag on DELETED().

Hi Josh, PMFJI, but I tested the same way Walter did with NOFILTER on. The Deleted index provided no benefit at all, possibly even slowing the query down a bit (though it was very close in my limited test). I have to use NOFILTER, else we get some major problems with creating writeable cursors with USE AGAIN, and occasionally without NOFILTER some very peculiar result sets show up in grids...I've removed all my Deleted indexes in the past week, and my SQL into cursors are running at least as fast as they were, with less CDX overhead...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Reply
Map
View

Click here to load this message in the networking platform