>It's already late here and I'm not sure I really understand what you are asking. "CDX bloat" as "formerly used but now unused space" hasn't changed in SP1. REINDEX still creates the index from the scratch using the definition stored in the index, INDEX ON still adds to the index file and DELETE TAG leaves the space in the file. What has changed is the way index nodes are created. I think in most database systems this is called a "fill factor".
>
So would it be fair to assume that the latest version of the VFP indexer works "more similarly" to the file system and indexer in SQL Server which allocates a fill factor in order to increase performance for OLTP?
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.