on 2014 Feb 20 3:44 PM
What is the best way to see how many row on each table, instead of using count()?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Excellent! thx!
You could also add a "Checkpoint;" command just prior to Volker's select to force more up-to-date counts.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.