易科 Exact Globe Next 数据库优化

 

打开数据库 如图片 依次设置框选的2项任务

ESI Optimizing Indexes

 

ESI Optimizing Statistics

 

 

 

 

优化数据库命令

第一个

 

dbcc showcontig(BACODISCUSSIONS) with fast, all_indexes, tableresults

 

第二个

 

SET NOCOUNT ON 

DECLARE @Table varchar(512) 

DECLARE @Index varchar(512) 

declare @Query nvarchar(512) 

DECLARE cur CURSOR FOR SELECT SO.name, SI.name FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, 'LIMITED')inner join sys.objects SO on

 SO.object_id=sys.dm_db_index_physical_stats.object_id inner join sys.indexes SI on SI.index_id=sys.dm_db_index_physical_stats.index_id and        

 SI.object_id = sys.dm_db_index_physical_stats.object_id WHERE sys.dm_db_index_physical_stats.index_id > 0    

 OPEN cur 

 FETCH NEXT FROM cur INTO @Table, @Index 

 WHILE @@FETCH_STATUS = 0 

 BEGIN 

 set @Query = 'DBCC DBREINDEX ([' + @Table + '],[' + @Index + '])'

 print @Query 

 EXEC sp_executesql @Query 

 FETCH NEXT FROM cur INTO @Table, @Index         

 End         

 Close cur         

 DEALLOCATE cur 

 SET NOCOUNT OFF