analyze table counterdb compute statistics; 记录不对 执行
select * from (select t.table_name as tableID,t.num_rows as recordCount from user_tables t) tt where tt.tableID='COUNTERDB' 统计表 COUNTERDB 记录数
analyze table counterdb compute statistics; 记录不对 执行
select * from (select t.table_name as tableID,t.num_rows as recordCount from user_tables t) tt where tt.tableID='COUNTERDB' 统计表 COUNTERDB 记录数
转载于:https://www.cnblogs.com/xsmhero/archive/2011/09/07/2170159.html