List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:March 30 2005 3:55pm
Subject:Re: Index on boolean column
View as plain text  
>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

Thread
Index on boolean columnDušan Pavlica30 Mar
  • Re: Index on boolean columnAlec.Cawley30 Mar
  • Re: Index on boolean columnMartijn Tonies30 Mar
  • Re: Index on boolean columnbeacker30 Mar
  • Re: Index on boolean columnDušan Pavlica31 Mar
  • Re: Index on boolean columnMartijn Tonies31 Mar
  • Re: Index on boolean columnMartijn Tonies31 Mar
  • Re: Index on boolean columnDušan Pavlica31 Mar
  • Re: Index on boolean columnMartijn Tonies31 Mar
Re: Index on boolean columnMartijn Tonies31 Mar