Re: Index on boolean column

[Dušan Pavlica]

> >maybe this is a silly question but how useful it is to create indexes on
>>columns containing only values 0 and 1 (true and false)?
>
> Perhaps, instead of the index, you might revise your schema a bit.
>
> Why do you have this boolean column? What are you trying to
> achieve?
>


I use boolean columns as a flags mostly to mark records as 'exported'. For 
example I have table 'Transactions' and I have to export data for some of 
our customers (never for all of them).

Dusan