Subject | Re: [firebird-support] Re: Ignoring a FK index |
---|---|
Author | Aage Johansen |
Post date | 2006-02-02T21:48:33Z |
Adam wrote:
look up 40% (or 60%) of the records than just scanning the whole table?
Just curious.
--
Aage J.
>> ...Is the index useful? I mean: is it really faster to follow an index and
> ...
> 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.
look up 40% (or 60%) of the records than just scanning the whole table?
Just curious.
--
Aage J.