>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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]