Subject Re: [ib-support] Index on Boolean-Col
Author Nando Dessena
Zile,

> >both you and Guido seem to imply that the value that you set with SET
> >STATISTICS is the selectivity of an index.
>
> I do not imply anything, just trying to better understand how IB works.

Sorry, bad choice of words on my part.

> >In particular, I don't think that the selectivity of an index is
> >something that IB keeps track of or use.
>
> Try this:
>
> select rdb$index_name, rdb$relation_name, rdb$statistics
> from rdb$indices
> where rdb$system_flag is null

The whole point of my post was exactly that this is not the selectivity
as Hellen (and a bunch of other people, including me, for that matter)
knows it.
See my reply to Guido.
Ciao
--
____
_/\/ando