Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Improve a requery
Message
 
 
To
11/08/2003 08:55:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00818689
Message ID:
00818860
Views:
23
>Try Cetin suggestion.
>
>It is usefull ( generally ) only for tables with more 50% record deleted.

That's not true. Also, with 50% or more deleted records even SEEK will take forever.

>It slow down the insert and delete process.

As any other index. There's nothing special aboud index on DELETED() in that regard.

>If is usefull, you need to implement a PACK process.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform