Re: index rebuild utility ..

From: "Sinha, Niraj" <niraj.sinha@BondBook.com> > >Is there any INDEX REBUILD utility which I can use ? >Also, any guidlines when and how often a table index should be rebuilt >?? >Also what is the best way - to drop and recreate. >While I am here, another question - how often to run ONCHECK commands, >and which all Well, if you SET INDEXES DISABLED, add a couple of rows to each table, then SET INDEXES ENABLED, your indexes will be dropped and recreated. However, for reliably compacted indexes, you should drop them all, then recreate them one at a time. _____________________________________________________________________________________ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com