begin
dbms_stats.gather_schema_stats(ownname => 'DEV',estimate_percent => 40,cascade => true);
end;
analyze table scott.emp compute statistics;
exec dbms_stats.gather_table_stats('SCOTT', 'EMP');
analyze table compute statistics for table;
begin
dbms_stats.gather_table_stats
( ownname => 'GAU01E',
tabname => 'G302T',
cascade => TRUE );
end;
阅读(833) | 评论(0) | 转发(0) |