A little off subject I know, but what is the purpose of an index?
On 21/04/06, 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. > > Thanks, > > Rusty > -- > Rusty Conover > InfoGears Inc. > > > >
