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
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
Martijn,
- Original Message -
From: Martijn Tonies [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, March 31, 2005 10:46 AM
Subject: Re: Index on boolean column
maybe this is a silly question but how useful it is to create
indexes
on
columns containing only values 0
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
I have to keep all transactions in one table for our reporting and
futher
analysing and if some other customers need exports I just can create
batch
sripts which will export their data for their own processing.
Thank you for your help and time and also thanks others which responded
to
Hello,
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)?
TIA,
Dusan
Du?an Pavlica [EMAIL PROTECTED] wrote on 30/03/2005 16:35:40:
Hello,
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)?
Since I believe that MySQL ignores indexes if it expects to get more than
30% hits, it
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
Duan Pavlica writes:
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)?
Most of the time I'd say such an index would not be real useful. If
the distribution of this column's values is equally distributed between
these
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
10 matches
Mail list logo