Subject | Re: Ignoring a FK index |
---|---|
Author | Adam |
Post date | 2006-02-02T22:35:59Z |
> > Indeed I did forget such unbalanced indices could be useful. In thisand
> > 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
> look up 40% (or 60%) of the records than just scanning the whole table?That was probably a bit confusing, there are more than two values, in
this particular customer there are only 7, (but that is unusually
low). The value 1 is contained in about 60% of the table, 2 through 7
are around 6% - 7% each.
Adam