Quote Originally Posted by prodadmin
thanks... u mean i shouldn't be doing coalesce and analyze ..
Always analyze my friend... Think carefully about index rebuilds. Is the effort of rebuilding them really outweighing the benefits? Google index rebuilds and you'll see lots of arguments against index rebuilds, and one or two that are for index "Burleson" rebuilds.