MSSQL - 인덱스 갱신 DECLARE @i int, @sql varchar(1000) DECLARE @tablename varchar(1000),@ownerName varchar(1000) SET @i = 1 DECLARE DB_Cursor CURSOR FOR SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_SCHEMA, TABLE_NAME OPEN DB_Cursor FETCH NEXT FROM DB_Cursor INTO @ownerName, @tablename WHILE @@FETCH_STATUS = 0 BEGIN SET @sql = 'ALTER IND..
원문링크 : MSSQL - 인덱스 갱신