Re: Actual Used space

Posted in 1996

Mark D Stock — Thu, 12 Sep 1996 10:46:24 -0700 — source: Informix-list mailing list archive (1991-1998)

Srinivas Reddy wrote: > > Correct me if I am wrong. > > npused is available in systables. > so you do not have to do a join. > just select the tabname and npused from systables. > > more specifically : select tabname,npused from systables where tabid >99 > if want this info for system catalogs then do not use tabid >99. Just make sure you do an UPDATE STATISTICS first. Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+