>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.