Sybase15: how to get memory of each table

 

declare @pagekb int

 

select @pagekb = low/1024

from master..spt_values

where number = 1

and type = 'E'

 

select user_name(o.uid) as 'owner',

o.name as 'table name',

i.indid,

case when i.indid in (0,1)

then data_pages(db_id(),o.id,0)

else data_pages(db_id(),o.id,i.indid)

end * @pagekb as 'used (KB)',

case when i.indid in (0,1)

then reserved_pages(db_id(),o.id,0)

else reserved_pages(db_id(),o.id,i.indid)

end * @pagekb as 'resvd (KB)'

from sysindexes i,

sysobjects o

where o.type = 'U'

and o.id = i.id

order by 2,1,3