SQL Server、db2和Oracle收集最新統計資訊

SQL Server：
DBCC UPDATEUSAGE
=> exec sys.sp_MsForEachTable 'select ''?'', count(*) from ? '
=> 把EXEC sys.sp_MSforeachtable結果存入暫存資料表

DB2：
RUNSTATS
=> select TABNAME,CARD from syscat.tables

Oracle：
DBMS_STATS
=> select table_name,num_rows from all_tables
REF:Oracle manually update statistics on all tables

Keyword: Updates statistics