getting row count in db2 using system tables?

Question

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(*) ?

+1 for anyone else getting here from Google trying to figure out how to do a select count(*) on a massive table! Thanks for your answer! — Jeffrey Knight
– Jeffrey Knight, Commented Feb 2, 2014 at 17:26

Fred Sobotka · Accepted Answer · 2009-06-26 07:51:07Z

1

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/

answered Jun 26, 2009 at 7:51

Fred Sobotka

5,33225 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

getting row count in db2 using system tables?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related