>Hi All.
>Till now i reindexed by taking the following steps:
>Delete Tag All
>Pack
>Recreate indexes.
>
>Today i've read Jim Nelson's comments about the PACK command:
>"The Hacker's Guide is also simply wrong when it asserts that REINDEX does not remove "bloat". It does remove bloat of both kinds and has done so for several releases now. And a PACK that does an internal REINDEX does write to a new CDX file (as does REINDEX itself)."
>
>So does it mean that one PACK will be enough to both properly reindex and pack a table?
>What would you suggest be a good reindexing procedure?
>Best wishes.
Kamil,
Since I've used what you're doing now since 2.0, I'd have to agree with Sergey that this is the best method. In order to reduce code redundancy, I stored the specific information regarding each table in another table.
George
Ubi caritas et amor, deus ibi est