Subject | Re: [ib-support] Index on Boolean-Col |
---|---|
Author | guido.klapperich@t-online.de |
Post date | 2001-08-19T11:25:47Z |
> No! this index would have the lowest possible selectivity, rendering it a Trojan Horse for performance.No, I just want to order by this column.
>
> Are you saying you want to ORDER BY this Boolean-style column (i.e. all the FALSE ones first?) Or do you want to combine it with another column?
Just for me to remember, selectivity is (1 / count of unique values) ?
And what does selectivity exactly mean and what it is used for ?
Guido