exec dbms_stats.gather_table_stats(ownname => ‘username’,tabname =>’table_name’,degree =>10,cascade =>true,estimate_percent =>25); 例如: exec dbms_stats.gather_table_stats(ownname => ‘test’,tabname =>’data_table1_name1′,degree =>4,cascade =>true,estimate_percent =>30); ...
11 中的第 1 个 拍品6 Ardbeg Uigeadail 54.2% (1) Coal Ila Moch (1) Glen Moray Peated Classic (1) Glenfiddich Rich Oak 40% (1) Glenglassaugh Revival 46% (1) Talisker Skye 45.9% (1) The Singleton of Glen Ord 18 Year Old 40% (1) The Singleton of Glendullan 12 Year Old 40% ...
exec dbms_stats.gather_table_stats(ownname => ‘username’,tabname =>’table_name’,degree =>10,cascade =>true,estimate_percent =>25); 例如: exec dbms_stats.gather_table_stats(ownname => ‘test’,tabname =>’data_table1_name1′,degree =>4,cascade =>true,estimate_percent =>30); ...