oracle 快速查询表记录数
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 记录数
![](http://www.cnblogs.com/images/cnblogs_com/xsmhero/20091027.jpg)
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 记录数