Un petit curseur pour réindexer toute la base; simple, efficace et pas cher !
USE MaBasegoDECLARE @TableName varchar(255)DECLARE TableCursor CURSOR FORSELECT table_name FROM information_schema.tablesWHERE table_type = 'base table'OPEN TableCursorFETCH NEXT FROM TableCursor INTO @TableNameWHILE @@FETCH_STATUS = 0BEGINDBCC DBREINDEX(@TableName,' ',90)FETCH NEXT FROM TableCursor INTO @TableNameENDCLOSE TableCursorDEALLOCATE TableCursorgo