查询大表数据不要用count,用这个语句
select table_name ,num_rows from all_tables s
WHERE upper(TABLE_NAME)=Upper('mfworkstatus');
查询大表数据不要用count,用这个语句
select table_name ,num_rows from all_tables s
WHERE upper(TABLE_NAME)=Upper('mfworkstatus');
转载于:https://www.cnblogs.com/turnip/p/11381635.html