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:
00198847
Views:
20
>My user will never delete more than 5% of records: they enter
>invoices, customers, goods and packing runs periodically, largest
>tables are 250000 records, 30 MB
>
>Do you agree that in this case index on deleted() will decrease the speed of queries?

No, I wouldn't say that...it just might not increase the speed much...
It's supposed to be more dependent on size than # of deleted's. I don't believe that's a large enough table for the deleted index to make a lot of difference in SQL, but were I you, I might test a little to compare the results, if you haven't done it yet...besides we're all curious about it, now :)
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform