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