Hi Fabio,

There're equal in the end result which is a cursor w/o indexes. However they're different in the process.

INDEX ON a TAG ix_a
INDEX ON a TAG ix_a

will increase the size of index file because space occupied by deleted index isn't reused by VFP. In the second case there wouldn't be any space wasted in CDX file. See http://fox.wikis.com/wc.dll?Wiki~CDXBloat~VFP for more details.


>Hi
>
>These commands
>
>CREATE CURSOR tab1 (a I)
>INDEX ON a TAG ix_a
>INDEX ON a TAG ix_a
>DELETE TAG ix_a
>
>are equal with these ?
>
>CREATE CURSOR tab1 (a I)
>INDEX ON a TAG ix_a
>REINDEX
>DELETE TAG ix_a
>
>Fabio