> > 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 respo
> >> > > >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 co
Martijn,
- Original Message -
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To:
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
> >
> > > >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
>
> > >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?
> >
>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 fla
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
thes
>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 Tonie
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, i
