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