Re: finding the large tables
Phillip
If your statistics are updated, then just get the nrows from systables, ie,
select tabname, nrows from systables
where tabid > 99
order by nrows desc;
HTH
Sujit
Phillip Tien <phillip.tien@wholefoods.com> on 01/10/2000 02:17:49 PM
Please respond to Phillip Tien <phillip.tien@wholefoods.com>
To: informix-list@iiug.org
cc:
Subject: finding the large tables
Anybody got a SQL script handy to find the largest tables in a database
(i.e. largest no. of rows) without having to hit each table manually?
In other words, one script that gets run once and returns the two
largest tables in a database.
--
Phillip