Subject Re: [firebird-support] Re: Index analysis - what does mean nodes, dup and max dup?
Author Kjell Rilbe
Ann W. Harrison wrote:
>
> Kjell,
> >
> > So, as a rule of thumb, you would use indexes to make it easier to find
> > the needles in the haystack, but not for finding the hay? :-)
> >
>
> Excellent analogy. If only the optimize had enough statistics to tell
> hay from needles...

Perhaps an idea for future improvement? I guess it wuld require a
different kind of index - some kind of hash buckets instead of b-trees?

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64