SET @RowThreshold = 1000 –Threshold for the number of rows. In the number of rows in the index is less that the threshold –then it will skip it completely.SET @PercentThreshold = 50 –FOR THIS SCRIPT 50 = 50% –Fragmentation threshold percentage. If greater than or equal to this amount them REBUILD the Index –If less than this amount REORGANIZE the index