Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is it reasonable to have index on DELETED()?
Message
From
21/03/1999 14:26:57
Walter Meester
HoogkarspelNetherlands
 
 
To
21/03/1999 09:09:10
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00196021
Message ID:
00200303
Views:
19
Bela,

>I usually SET DELETED ON, and make many SQL SELECT with complex WHERE clauses. Only one of my tables contains deleted records. Should I make tag on deleted() in all table?

NO, Only tables with more than just a few deleted records in it would benefit from a tag on deleted().
Previous
Reply
Map
View

Click here to load this message in the networking platform