Sunday, February 19, 2012

About rebuilding index

Hi,

Maybe a silly question, but... Are DBCC DBREINDEX and sqlmaint -RebldIdx doing exactly the same thing ? I mean, I know they are both rebuilding index, with optionnally precising a new fillfactor, but are they processing this operation by the same way ? If not, which is best ?

ThanksStick with DBCC DBREINDEX - safer & works just as well.

If you are working on very large tables then you would start looking at options at that point.

Cheers,

SG|||That's just what I was suspecting.

Thanks for answer :)

No comments:

Post a Comment