by ChrisC <cunningham.cb@[EMAIL PROTECTED]
>
Apr 30, 2008 at 09:56 AM
--CELKO-- wrote:
> Is there a simple way to get a COUNT(*) for all tables in a schema in
> DB2 LUW 9.0?
Well, if the tables are mostly static and you have current statistics
OR your tables are very dynamic and you have sufficiently recent
statistics, selecting from the catalog works great:
select tabname, card from syscat.tables where tabschema =
'<schemaName>'
(noting that for very dynamic table sizes, the exact COUNT(*) isn't
often accurate in any case for long).
