getting row count in db2 using system tables?
18,154
A materialized query table (MQT) is another option, but it is only available for more expensive DB2 product licenses. Here's an overview: http://www.ibm.com/developerworks/db2/library/techarticle/dm-0509melnyk/
Author by
urmalp
Updated on June 04, 2022Comments
-
urmalp almost 2 years
I can get row count from system table in db2 using
select tabname,card from syscat.tables where tabname='?'
but this will give static row count,If I need to get dynamic one I need to run runstats on the table. is there any other way apart from using count(*) ?