Rebuild indexes on Filegroup

Question

How to rebuild all indexes on all tables in single file group in sql server 2016?

Answer 1

Hi @Vijay Kumar ,

Try below T-SQL;

SELECT  
  
  sd.name AS FileGroupName,  
  
  st.name AS TableName,  
  
  si.name As IndexName,  
  
  sd.name data_space_name,  
  
  'DBCC DBREINDEX("' + SCHEMA_NAME(st.schema_id) + '.' + st.name + '", ' + QUOTENAME(si.name) + ')' AS ReIndexCommand  
  
FROM sys.indexes si  
  
INNER JOIN sys.tables st ON si.object_id = st.object_id  
  
INNER JOIN sys.data_spaces sd ON si.data_space_id = sd.data_space_id  
  
   WHERE sd.name = 'filegroupname'  

Quote from this similar thread REBUILD THE INDEXES BY FILE GROUP .

---

If the response is helpful, please click "Accept Answer" and upvote it, thank you.