[sqlite] Rule of thumb for estimating index size

[Rusty Conover]

Hi,

Is there an easy way to get an estimate on the space used by an  
existing index?  If not what is a good guess on how to estimate the  
size?

My guess would be (assuming text fields are being indexed):

[total length of all index keys] + [number of rows]*8 (for the offset  
location)

Is that close? I realize disregards all space used by page allocation  
overhead.

Thanks,

Rusty
--
Rusty Conover
InfoGears Inc.