What is the best way to see how many row on each table, instead of using count()?
asked 20 Feb '14, 15:43
If approximate numbers are sufficient, you can query the system catalog (row numbers are updated on each checkpoint):
select table_name, count from systab order by table_name
answered 20 Feb '14, 16:33