rebuilding indexes

In 7.3, are there other ways to rebuild indexes other than dropping and re-creating them? - David

David Palmer wrote: > In 7.3, are there other ways to rebuild indexes other than dropping and > re-creating them? > DISABLE then ENABLE index(es) will cause them to be rebuilt: SET INDEXES FOR <tablename> DISABLED; -- All indexes on a table -or- SET INDEXES <indexname1>[, <indexname2>] DISABLED; -- Specific indexes -- Note no FOR <tablename> clause Then later: SET INDEXES FOR <tablename> ENABLED; -or- SET INDEXES <indexname1>[. <indexname2>...] ENABLED; Art S. Kagel