Subject RE: [IB-Architect] Index Selectivity Question (RFC)
Author Dmitry Yemanov
Hi Joseph,

> I would just like to request for comments on my article below
> so that I
> will know if my views are correct or not. This is with regards to
> whether we will just continue to blindly follow the AVOID INDEX
> SELECTIVITY mantra, or actually harness the extreme power of Interbase
> sparse indexes which is actually optimized for INDEX
> SELECTIVITY - which
> is the reverse of AVOID SELECTIVITY.
>
> I also invite others to confirm my findings. So, here goes:
>
> [very big snip]

I cannot be considered as an engine guru, but I was always thinking that in
InterBase the internal index implementation somehow combines elements from
both b-tree and bitmap technologies. Am I wrong?

Cheers,
Dmitry