Subject | Re: [firebird-support] Index Memory Usage |
---|---|
Author | Ann Harrison |
Post date | 2015-03-18T02:23:44Z |
On Mar 17, 2015, at 1:55 AM, Ekundayo edayo_a@... [firebird-support] <firebird-support@yahoogroups.com> 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
Build your indexes both ways and use gstat to estimate their usage. My gues is that BigInt wins, but that's a guess.\
\
Good luck,
Ann