Hi everyone.
Is there a way to find out how many records are contained in a specific DB2 table without using SELECT COUNT...FROM the table?
For example, is there a SYS table which contain this (or a similar) information?
I cannot use the SELECT COUNT...FROM because I show a list of DB2 table in an .asp page over the internet; if one or more table of the list contains a lot of records (say more than 100.000) and I retrive it with SELECT COUNT...FROM my web page is really too slow to load.
Any help will be greatly appreciated.
Thanks in advance
David
Is there a way to find out how many records are contained in a specific DB2 table without using SELECT COUNT...FROM the table?
For example, is there a SYS table which contain this (or a similar) information?
I cannot use the SELECT COUNT...FROM because I show a list of DB2 table in an .asp page over the internet; if one or more table of the list contains a lot of records (say more than 100.000) and I retrive it with SELECT COUNT...FROM my web page is really too slow to load.
Any help will be greatly appreciated.
Thanks in advance
David