Re: Smart way to calculate size of a table!

From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1996/02/14
Message-ID: <4fsu0t$dhe_at_reader2.ix.netcom.com>#1/1

Amin Adatia <amin_at_magi.com> wrote:

>Hi!

>Analyze the Table with either ESTIMATE/COMPUTE Statistics.
>Then use the AVG_ROW_LEN * NUM_ROWS to get the size.

>Regards

This will tell you the amount of data space consumed by the table, but doesn't take into consideration the block headers. The best formula is the one found in the administrator's guide, chapter 8.

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Never share a foxhole with anyone braver than yourself!

Received on Wed Feb 14 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Joel Garry: "Re: ANNOUNCE: Vacant Job Positions"
Previous message: Michael J. Saylor: "Re: Announcing the "Instant Data Warehouse" Product"
Maybe in reply to: Magnus Rosenquist: "Smart way to calculate size of a table!"
In reply to Amin Adatia: "Re: Smart way to calculate size of a table!"
Next in thread: Joel Garry: "Re: ANNOUNCE: Vacant Job Positions"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message