Oracle: DBMS_STATS的分析表与备份恢复的一点SQL
2011-08-03 15:27 Tracy. 阅读(417) 评论(0) 编辑 收藏 举报 begin
dbms_stats.gather_table_stats(ownname => USER, tabname => 'TMS_ROUTE_HEADER');
end;
BEGIN
DBMS_STATS.set_table_stats (ownname => USER,
tabname => 'TMS_ROUTE_HEADER',
numrows => 100,
numblks =>5
);
END;
begin
dbms_stats.delete_table_stats(ownname => USER,
tabname => 'TMS_ROUTE_HEADER');
end;
select count(1) from tms_route_header rh, tms_route_stop rs
where rs.truck_route_instance_id=rh.truck_route_instance_id;
begin
dbms_stats.create_stat_table(ownname => 'TMS',stattab => 'STAT_TABLE');
end;
begin
dbms_stats.import_table_stats(ownname => 'TMS',tabname => 'TMS_ROUTE_HEADER',stattab => 'STAT_TABLE');
end;
begin
dbms_stats.export_table_stats(ownname => 'TMS',tabname => 'TMS_ROUTE_HEADER', stattab => 'STAT_TABLE');
end;
select * from STAT_TABLE
本文来自博客园,作者:Tracy.,转载请注明原文链接:https://www.cnblogs.com/tracy/archive/2011/08/03/2126264.html