Subject | Re: [firebird-support] Re: Index analysis - what does mean nodes, dup and max dup? |
---|---|
Author | Kjell Rilbe |
Post date | 2008-11-23T05:22:59Z |
Ann W. Harrison wrote:
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
>Perhaps an idea for future improvement? I guess it wuld require a
> 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...
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