how to perform Rebuild index faster.

Hi Team,

At the moment I am making use of below query for rebuilding the index,

ALTER INDEX ALL ON TABLE_NAME REBUILD(We are performing the same on 6 tables), As the data is very huge, it is taking 1hr for INDEX rebuild,

Please could you suggest a better way to perform the rebuild indexing faster?

Note: All the tables indexes are non clustered.

Regards,

Rajendra

July 29th, 2015 2:06am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics