Subject Re: [firebird-support] Index Memory Usage
Author Ekundayo
Thank you for the information, I'll do as you suggested and use (read up) on gstat.

Sent from Yahoo Mail for iPad

At Mar 18, 2015, 8:00:59 PM, Thomas Steinmaurer ts@... [firebird-support]<''> wrote:

> 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.