To Get all index size in a Database :sp__getallindexsize
I used the posted method to calculate index size : Calculating Table & Index Usage in ASE
Down load the stored proc here: sp_getallindexsize.sql (9)
Check the Sybase Wiki @ sybasewiki.com1> use pubs3
2> go
1> sp__getallindexsize
2> go
table_name index_name size reserved unused
————— ——————— —– ——– ——
authors aunmind 2 KB 32 KB 30 KB
roysched titleidind 2 KB 32 KB 30 KB
titleauthor auidind 2 KB 32 KB 30 KB
salesdetail titleidind 2 KB 32 KB 30 KB
titleauthor titleidind 2 KB 32 KB 30 KB
salesdetail salesdetailind 2 KB 32 KB 30 KB
titles titleind 2 KB 30 KB 28 KB
blurbs tblurbs 14 KB 16 KB 2 KB
sales sales_8320029642 2 KB 16 KB 14 KB
stores stores_7840027932 2 KB 16 KB 14 KB
titles titles_6720023942 2 KB 16 KB 14 KB
authors authors_5760020522 2 KB 16 KB 14 KB
publishers publishers_6240022232 2 KB 16 KB 14 KB
store_employees store_empl_8960031922 2 KB 16 KB 14 KB(14 rows affected)
(return status = 0)
Anurag has more than 6+ years of experience in Sybase Database Development .His Area of expertise includes Performance, Query Optimization, Cost Optimization, TSQL Development. He is also involved in Consultancy to Financial Firms for Database Implementation and Maintenance. He has supported many Global Financial firms.