On 1/5/06, me@alternize.com <me@alternize.com> wrote:
> hi list
>
> does an index over a boolean field make sense performance-wise? 1/3 of all
> records are set to true... what index type if any would be best?
>
> thanks,
> thomas
only if you create a partial index, using the expression that will
contain the smallest fraction of values...
but for a third part of the records i don't think it will be a win...
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)