Hi Friends,

I want to build a query which will give me the output like that:-

Table size indid

Table1 234455K 0
Index1 2323K 3
Cl_index 232323K 1

In short I want to pick up all the rows from sysindexes
a. where id > 100
and Size of each table ,clustered index, nonclustered index.

I know we have only one procedure sp_spaceused which will give you the size
but that cann't help when you are writing a query.
Kindly suggest any query or scripting

Regards

issues_sybase (AT) hotmail (DOT) com (Lalit) wrote in message news:<7bcd3933.0401130906.456db21f (AT) posting (DOT) google.com>...

It can certainly help if you look at the sourcecode for sp_spaceused.

use sybsystemprocs
go
sp_helptext sp_spaceused
go

But as a start, something like

select object_name(id) as "table name", name as "index name", indid,
reserved_pgs(id,dpgs)
from sysindexes where id > 100


-bret