From: Martijn Tonies
Date: March 30 2005 3:55pm
Subject: Re: Index on boolean column
List-Archive: http://lists.mysql.com/mysql/181898
Message-Id: <001301c53540$ef992f60$3802a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-2"
Content-Transfer-Encoding: 7bit

>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?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com