sqlserverインデックス

差分

このページの2つのバージョン間の差分を表示します。

この比較画面へのリンク

--- sqlserverインデックス [2014/02/22 09:45] – 作成 nabezo
+++ sqlserverインデックス [2014/07/26 10:04] – [断片化の取得] nabezo
@@ 行 41: / 行 41: @@
   b.name
+====インデックスの再構築====
+  USE [DAIKO_MAIN]
+  GO
+  DECLARE @TableName sysname, @IndexName sysname
+  DECLARE @basesql nvarchar(max), @sql nvarchar(max)
+  DECLARE @Edition nvarchar(max)
+  SET @Edition = CONVERT(nvarchar, SERVERPROPERTY(‘Edition’))
+  SET @basesql = ‘ALTER INDEX @1 On @2 REBUILD @3′
+  IF PATINDEX(‘%Enterprise%’, @Edition) > 0
+  BEGIN
+    SET @basesql = REPLACE(@basesql, ‘@3′, ‘WITH (ONLINE=ON)’)
+  END
+  ELSE
+    SET @basesql = REPLACE(@basesql, ‘@3′, ”)
+  DECLARE IXC CURSOR FOR
+  SELECT
+    OBJECT_NAME(object_id) AS TableName
+    , name AS IndexName
+  FROM
+    sys.indexes
+  WHERE
+    OBJECT_SCHEMA_NAME (object_id) <> ‘sys’
+    AND
+    index_id > 0
+  ORDER BY 1
+  OPEN IXC
+  FETCH NEXT FROM IXC
+  INTO @TableName, @IndexName
+  WHILE @@FETCH_STATUS = 0
+  BEGIN
+    PRINT @TableName + ‘:’ + @IndexName
+    SET @sql = REPLACE(@basesql, ‘@1′, @IndexName)
+    SET @sql = REPLACE(@sql, ‘@2′, @TableName)
+    EXECUTE (@sql)
+    FETCH NEXT FROM IXC
+    INTO @TableName, @IndexName
+  END
+  CLOSE IXC
+  DEALLOCATE IXC

sqlserverインデックス.txt · 最終更新: 2019/06/30 12:22 by 127.0.0.1