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 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]