生成指定表rebuild所有索引的语句

生成指定表rebuild所有索引的语句2014-03-14 csdn博客 ocpyang需要对表大数据量操作的时候，如delete，需要对索引可以选择性的操作！可以使用下面语句生成:

declare @tname varchar（100）declare @size intset @size=0 --这里设置索引大小限制，如果不设置默认为0即所有索引 set @tname='tblorders'select 'alter index '+' '+c.indexname+' '+'on'+' '+@tname+' '+'rebuild with （data_compression=page）'from （select * from （SELECTOBJECT_NAME（i.OBJECT_ID） AS TableName,i.name AS IndexName,i.index_id AS IndexID,8 * SUM（a.used_pages）/1024 AS 'Indexsize（MB）'FROM sys.indexes AS iJOIN sys.partitions AS p ON p.OBJECT_ID = i.OBJECT_ID AND p.index_id = i.index_idJOIN sys.allocation_units AS a ON a.container_id = p.partition_idGROUP BY i.OBJECT_ID,i.index_id,i.name）awhere a.tablename=@tname and [Indexsize（MB）]>@size ）c