> 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
http://www.upscene.com/
Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.