Esteban,
Every time you add a TAG to the CDX it stays until you DELETE TAG ALL as you have seen. If you want temporary indexes, then use IDX files. If you're only using a portion of the table, use a cursor and index it on the fly.
HTH
Barbara
>Hi all,
>I have a temporary index to a table in one process. And when it is not useful I delete it.
>But... Taking a look to the directory, I can see that the .CDX size is very large.
>My code is:
>
>Use mytable Exclusive
>INDEX ON myfield FOR mycondition TAG aux
>...
>... && my process here
>...
>SELECT mytable
>DELETE TAG aux
>
>Any suggestion ??? Thanks in advance!
>
>Note: My table have 20 records and the size is 2K. The CDX file have a size of 9400K -- IMPOSIBLE!!!!!!! If I do a DELETE TAG ALL command the .CDX go to 0.3K