Rebuilding Indexes on Databases

For improved performance during data exchange, it is recommended that you rebuild indexes on your AVEVA NET Workhub and Dashboard and AVEVA Change Manager databases. The rebuilding of indexes speeds up the check-in or check-out of Working Sets that contain huge amount of data.

To rebuild the indexes on the AVEVA Change Manager database:

1. Open Microsoft SQL Server Management Studio.

2. In the Object Explorer, connect to your AVEVA Change Manager database.

3. In the query window, run the following query:

   DECLARE @TableName VARCHAR(255)
   DECLARE @sql NVARCHAR(500)
   DECLARE @fillfactor INT
   SET @fillfactor = 80
   DECLARE TableCursor CURSOR FOR
   SELECT OBJECT_SCHEMA_NAME([object_id])+'.'+name AS TableName
   FROM sys.tables
   OPEN TableCursor
   FETCH NEXT FROM TableCursor INTO @TableName
   WHILE @@FETCH_STATUS = 0
   BEGIN
   SET @sql = 'ALTER INDEX ALL ON ' + @TableName + ' REBUILD WITH (FILLFACTOR = ' + CONVERT(VARCHAR(3),@fillfactor) + ')'
   EXEC (@sql)
   FETCH NEXT FROM TableCursor INTO @TableName
   END
   CLOSE TableCursor
   DEALLOCATE TableCursor
   GO

4. To update the statistics, execute the sp_updatestats command in the query window.

This rebuilds the AVEVA Change Manager database indexes.

To rebuild the indexes on AVEVA NET Workhub and Dashboard database, connect to the database in Microsoft SQL Server Management Studio, and then repeat steps 2 through 4.