Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index taking up too much disk space
Message
From
04/12/2005 10:59:26
 
 
To
04/12/2005 03:31:16
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:
01074723
Views:
24
The index expression is a large string..

I'm using:

BINTOC(table1.primarykey) + BINTOC(table1.secondarykey) + BINTOC(table2.primarykey) + BINTOC(table2.secondarykey) + BINTOC(table3.primarykey) + BINTOC(table3.secondarykey)

Are you saying I can get the same result from a different, smaller index expression but still reference these three tables and all 6 fields?

Thanks.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform