RE: Table are getting to large
update statistics low;
select tabname, nrows
from systables
where tabid > 99
and tabtype = "T";
Wayne E. Martin
Informix Database Administrator
Kmart Corp.
-----Original Message-----
From: Shivvers, CC [mailto:CShivvers@hy-vee.com]
Sent: Tuesday, January 02, 2001 3:31 PM
To: informix-list@iiug.org
Subject: Table are getting to large
I need a simple way to monitor flow of data through all of my tables. Is
there a command to tell me how many records are in all tables or do I have
to specify each table? Right now I have approx. 750 tables. onstat -d tells
my chunk size but not the table names that have grown to large.
CC Shivvers
Hy-vee, inc.