Rusty Conover <[EMAIL PROTECTED]> wrote: > 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. >
The sqlite3_analyzer executable available on the website will tell you exactly how much space an index uses. This utility is not suitable for use at run-time, but you can use it to validate the accuracy of your estimate. -- D. Richard Hipp <[EMAIL PROTECTED]>