Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Collate - Index on Deleted() Tag DeletedTag Binary
Message
From
26/08/2005 20:04:53
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
26/08/2005 13:22:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01044347
Message ID:
01044474
Views:
19
>"However this index is useless"! This information is completely wrong!!! A binary index tag on deleted() can speed up your queries a lot, unlike orinary index tag on deleted() in previous versions of VFP. But I expect you to deny this statement. (Sigh in advance!)

I tend to think of an index on deleted() more likely to be harmful than helpful - what sort of improvements have been made in recent versions?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform