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

I would suggest using Ola's great script to rebuild index faster and smarter :-)

https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html