Regeneration d'index

Bonsoir

ce script devrait faire l'affaire:
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
CREATE PROCEDURE RedoStatsAndIndexes
AS
 
DECLARE @MyTable varchar(255)
 
DECLARE myCursor CURSOR FOR
    SELECT table_name FROM information_schema.tables
       WHERE table_type = 'base table'
       OPEN myCursor
 
         FETCH NEXT FROM myCursor INTO @MyTable
          WHILE @@FETCH_STATUS = 0
               BEGIN
             PRINT 'Reindexing Table:  ' + @MyTable
             DBCC DBREINDEX(@MyTable, '', 90)
             FETCH NEXT FROM myCursor INTO @MyTable
           END
 
                  CLOSE myCursor
 
       DEALLOCATE myCursor
EXEC  sp_updatestats