Fwd: Sizes of Tables (Fragmented or Not) and Indices (Attached or Not,
Oh, I have this for some of it ...
-----------------------------------------------------------------------------
-- Module: @(#)tabextent.sql 1.4 Date: 97/07/18
-- Author: Lester B. Knutsen Email: lester@advancedatatools.com
-- Advanced DataTools Corporation
-- Discription: Displays tables, number of extents and size of table.
-----------------------------------------------------------------------------
database sysmaster;
select dbsname,
tabname,
count(*) num_of_extents,sum( pe_size ) total_size
from systabnames, sysptnext
where partnum = pe_partnum
group by 1, 2
order by 1, 2
"Clifton M. Bean" <cmbean@sbcglobal.net> wrote:
Date: Fri, 4 Mar 2005 08:06:50 -0800 (PST)
From: "Clifton M. Bean"
Subject: Sizes of Tables (Fragmented or Not) and Indices (Attached or Not,
Fragmented or Not)
To: Informix Email List , SAPMIX
Does anyone have any one or multiple scripts that will output that type of
information, in pages or KB, for a specified database or for an entire
instance?
I know .... I know ... asking for a miracle here but just thought I'd ask for
a little help from my friends :)
Thanks in advance.
Clifton