Oninit cdi / Archive
Talk to an expert →

How much diskspace is used by indexes

Posted in 2000

Topics: General Discussion

Driekus Heijsteeg — — source: Informix-list mailing list archive (1991-1998)

I know how to calculate tablesizes in Mb. I also want to calculate diskspace taken by indexes for 1 table.

↪ replying to Driekus Heijsteeg
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)

Run onstat -pT it will document the number of pages of data and indexes for the table. Then just multiply by your platform's pagesize (2k or 4k) to get KB. Actually you can multiply by pagesize - 24 to account for overhead on each page. Art S. Kagel Driekus Heijsteeg wrote: > > I know how to calculate tablesizes in Mb. I also want to calculate diskspace > taken by indexes for 1 table.

Related threads