Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is it reasonable to have index on DELETED()?
Message
From
16/03/1999 23:09:25
Chaim Caron
Cleveland, Ohio, United States
 
 
To
16/03/1999 08:15:32
Walter Meester
HoogkarspelNetherlands
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:
00198424
Views:
26
Walter,
If you don't have SET DELETED ON, the index is not so important. But if you do have SET DELETED ON, then the index is important and it does not matter what percent of the records are deleted. The only case where the index on DELETED() is not important is if you very few recrods or if SET DELETED is OFF.
Regards, Chaim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform