Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index taking up too much disk space
Message
From
05/12/2005 12:46:37
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP
Network:
Novell 6.x
Database:
MySQL
Miscellaneous
Thread ID:
01074663
Message ID:
01074999
Views:
25
Hi Naomi,

>>huh? locate for command is fast if there are all aprropriate indices that match left part of index expression.
>>and i think that locate for field1=key1 and field2=key2 will be blazingly fast when there are indices for field1 and field2 and index on deleted().
>
>With index on DELETED() you're going into the battle field <g>

am i missing something???
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform