sybase: fetch table size and indexes size

Pretty easy, use the sp_spaceused stored procedure as follow:

sp_spaceused my_table_name
go

To focus on indexes for a given table, you can call sp_helpindex <index_name> query as follow:

exec sp_helpindex  'my_table_name'
go


sources

Post a Comment

Your email is never published nor shared. You're allow to say what you want...