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!
(20 Feb '14, 16:50)
pLee
1
You could also add a "Checkpoint;" command just prior to Volker's select to force more up-to-date counts.
(20 Feb '14, 18:48)
Bill Aumen
|