Subject Re: [firebird-support] Re: Ignoring a FK index
Author Aage Johansen
Adam wrote:
>> ...
> ...
> Indeed I did forget such unbalanced indices could be useful. In this
> case, the index is reasonably balanced. There is one value that is
> contained by about 40%, the other 60% is roughly even split.

Is the index useful? I mean: is it really faster to follow an index and
look up 40% (or 60%) of the records than just scanning the whole table?
Just curious.

--
Aage J.