Re: size taken up in tables

Oxnard wrote:

> db 9.2.0.5
> OS AIX 5.2
> Character set: UTF8
>
> How can I determine in bytes how much space is taken up by date data and
> number data?
> I seem to vaguely recall a number and a date each always take the same
> amount of space in a column of that type irregardless of the value.
>
> Thanks

SELECT dump(column_name)
FROM table_name;

SELECT vsize(column_name)
FROM table_name;

Or, of course, read the docs bcause your vague recall is wrong with respect to numbers.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)