[Author]:
Fu Renjie
-- Mysql快速统计行数;
use db_analyst_crm;SELECT TABLE_SCHEMA,TABLE_NAME,TABLE_ROWS,DATA_LENGTH/1024/1024 "DATA_LENGTH",CREATE_TIME,TABLE_COLLATIONFROM INFORMATION_SCHEMA.TABLES-- WHERE TABLE_SCHEMA = 'root'ORDER BY TABLE_SCHEMA,TABLE_ROWS DESC;
-- 如何快速的获取oracle数据库中表中记录行数,不使用select count(1)方式:
-- 1.更新整个用户所有表的统计数据更新SQL> EXEC dbms_stats.gather_schema_stats('【username】',estimate_percent=>100,cascade=> TRUE);
-- 2.查询统计:select TABLE_NAME, CC.num_rows, CC.last_analyzedfrom tabs CC
--SQLServer中 快速统计各个表中的行数。
select schema_name(t.schema_id) as [Schema], t.name as TableName,i.rows as [RowCount],i.minlen, i.xmaxlenfrom sys.tables as t, sysindexes as iwhere t.object_id = i.id and i.indid <=1