>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
Hello
I suggest deleting the indexes and recreating them. Storing the index info in a metadata table will help, because you can automate this task.
Hope this helps
Grigore Dolghin
Class Software.