efcharvet 0 Report post Posted February 26, 2007 This is a very, very minor thing... I do not see any virtue in keeping "Reindex" and "Optimize" as separate Maintenance functions. Please combine them in the next release of TMG. Thanks, Earl Share this post Link to post Share on other sites
GenerationGoneBy 0 Report post Posted February 26, 2007 Earl, When you run OPTIMIZE, it does reindex. Reindex does not optimize. Share this post Link to post Share on other sites
efcharvet 0 Report post Posted February 27, 2007 Earl,When you run OPTIMIZE, it does reindex. Reindex does not optimize. I didn't realize that. It doesn't mention anything about that in the manual (see page 52) or in the Help. (I may be mistaken, but I think in TMG v.3 and/or v.4, you had to reindex before optimizing... Oh well. No big deal.) I won't be using Reindex in the future, only Optimize. Thanks much, Earl Share this post Link to post Share on other sites
Jim Byram 0 Report post Posted February 27, 2007 Reindex bebuilds the indexes with no change to the data tables. Optimize compacts the data tables and, by necessity since the data tables have changed, reindexes. Share this post Link to post Share on other sites