All-
We've been running into some serious issues lately that I think may stem from our indexes being way too large and fragmented. In looking into a way to do this in a scheduled manner I found UP_REBUILD_ALL_INDEXES.
Does anyone use this procedure in a scheduled task, and if so, when?
Also, without looking at the code yet, does anyone know off hand if this fully rebuilds the indexes, or just reorganizes them?
Thanks,
Chris
Hi Chris
It rebuilds them all (offline), just like it says. If your db is largeish, and heavily fragmented it can take a long time, and take indexes offline while it works on them.
You certainly should be defragmenting indexes regularly though. Have a look at this forum thread for some other comments and suggestions from me....
Ken