Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CLOSE INDEXES close structural indexes!
Message
From
24/12/2007 06:14:40
 
 
To
24/12/2007 05:25:09
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01277227
Message ID:
01277295
Views:
29
Tore,
>The cdx structure has an advanced form of compression built in.
>
>MyTable.dbf: 5,580,078 records
>Myfield: C(60)
>Index on myfield to temp && 465,009 bytes
>Index on Myfield tag temp of tempcdx && 176,362 bytes

Serves me right to have given that unexact specs<g>
More apples to apples:

Index on myfield to temp Compact && ?? bytes


tg
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform