Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is it reasonable to have index on DELETED()?
Message
From
15/03/1999 22:52:52
Chaim Caron
Cleveland, Ohio, United States
 
 
To
14/03/1999 14:54:35
Andrus Moor
Tallinn, Estonia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Is it reasonable to have index on DELETED()?
Miscellaneous
Thread ID:
00196021
Message ID:
00197913
Views:
25
Hello Andrus,
If you have a large table and you SET DELETED ON, then you need the index on DELETED() regardless of how many records are deleted. If you do not have an index on DELETED(), VFP has to inspect each record to determine whether or not to present it. Thus, you lose all Rushmore optimization.
Regards, Chaim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform