Subject Re: [firebird-support] Index Memory Usage
Author Thomas Steinmaurer
> Hi All, can anyone tell me (or point me in the direction of manuals) how
> i can calculate the amount of memory used by the indexes of a particular
> table?
> I have a table in which I store sha1 hashes (currently about 2 million
> records) as char(40) and its indexed, I'm wondering if the table would
> consume less memory if the hashes are stored as BIGINT

Use gstat -i to get the number of data pages occupied by an index
multiplied by the page size of the database. This should give you a
rough estimation on disk space used in KB for an index.

With regards,
Thomas Steinmaurer

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.