Joined: 31 Oct 2006 Posts: 959 Location: Richmond, Virginia
If your table is huge, SELECT COUNT(*) may not be preferable.
The SYSIBM.SYSTABLES table has this column:
Total number of rows in the table or total number of LOBs in an auxiliary table. The value is -1 if statistics have not been gathered or the row describes a view, alias, or created temporary table. This is an updatable column