In addition to destory the "holes" in the index, optimization is also used to merge multiple small indexes into a bigger one. Although I have not got specific performace data, I can imagine that this will lead to performace benifits. Supposing you have thousands of small indexes, open-close these indexes again and again should be time costing.
2010/1/30 Marcus Herou <marcus.he...@tailsweep.com> > If one only have additions do I then need to optimize the index at all ? > > I thought that only update/deletes created "holes" in the index. Or should > the index be sorted on disk at all times, is that the reason ? > > Cheers > > //Marcus > > -- > Marcus Herou CTO and co-founder Tailsweep AB > +46702561312 > marcus.he...@tailsweep.com > http://www.tailsweep.com/ > -- 梅旺生