Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete Tag
Message
 
To
22/09/2004 10:34:50
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00944983
Message ID:
00945248
Views:
26
>Hi all
>
>I have a database table with compound structural index. As I do not use persistent relationships in my DBC, I issue the following command :
>
>USE mytable
>DELETE TAG mytag
>INDEX ON myfield TAG mytag
>
>I realised the CDX size increases when I do this. I tried DELETE ALL TAG and recreate all the tags but again the CDX size increases. I'm using VPM7. Is there any reason that the CDX size should increase. Your advice most appreciated.
>
>Thanks & Best Regards

If you PACK the file, the CDX will shrink again. You need exclusive use to do a PACK, but you need that to build the index too, so you should already have it.
Previous
Reply
Map
View

Click here to load this message in the networking platform