online index rebuild or index shrink space compact.
646155Sep 20 2010 — edited Sep 20 2010hello guys,
can any one tell me the details whether the index rebuild is a better option or the index shrink space compact is a better option if the index is fragmented. which one will result in the better performance once the rebuild or shirk space compact is performed.