Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Full Optimize this
Message
From
07/03/2013 14:06:09
 
 
To
07/03/2013 11:43:39
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01567687
Message ID:
01567785
Views:
42
>Mike,
>
>your comment about index tags on deleted() are not valid anymore! VFP9 introduced binary tags, which makes that old discussion invalid. "Index on deleted() tag deleted binary" will in most cases result in much quicker Selects than without the index tag.

What binary tags do is raise the number of records for which having the tag is a better choice than not having it.

Tamar
Previous
Reply
Map
View

Click here to load this message in the networking platform