Oracle重新获取统计信息以及SQLSERVER重建索引

Oracle重新获取统计信息

exec dbms_stats.gather_schema_stats(ownname =>'LCoe739999',options => 'GATHER',estimate_percent => dbms_stats.auto_sample_size, method_opt => 'for all columns size repeat', degree => 4)

SQLSERVER重新新建所有表的索引.

EXEC SP_MSFOREACHTABLE 'dbcc DBreindex("?")'

转载于:https://www.cnblogs.com/jinanxiaolaohu/p/7953416.html