>what is the best way to reorganize the indexes of a certain table: the REINDEX command or droping all indexes and recreating them?
>
>I´m asking this because I want to create a generic class that reindexes all the tables (from all databases) in one application. If you have some suggestions about this, please, let me know! ok??
>
>TIA
>
>Alonso

REINDEX relies on the key information stored in the header of the CDX. If that is corrupt, it will not properly rebuild the index. Also, REINDEX causes CDX file bloat. The best way is to DELETE TAG ALL then INDEX. Be careful though. If you are using any persistant relations, deleting the index tag will also delete the relation. I highly recommend using a tool like Stonefield data tools that keeps track of all the keys and relations and rebuilds them.