Hi!
There are REINDEX command. Sometimes it is buggy, so the best way is to keep you index definitions stored somewhere and re-create them. You can use DELETE TAG command to delete existing index tag.
In addition, just go to the help for 'INDEX' commend and look to 'See Also'. You will find a lot of functions and commands that could be used, covering all tasks related to indexes.
HTH.
>Dear all,
>
>How to write a routine to reindex the tables?? Is there a method firstly delete the tag files and regenerate a new set of index files??
>
>With regards,
>
>Ransome
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.