Re: Index on a (homemade) SET?

2003-03-20 Thread harm
On Thu, Mar 20, 2003 at 05:06:09PM +0100, Benjamin Pflugmann wrote: > Hi. > > On Thu 2003-03-20 at 15:52:25 +0100, [EMAIL PROTECTED] wrote: > > > > I use a lot of SET-alike fields in my tables. The fields are used to store > > properties and such; every bit stands for a specific value. The fields

Re: Index on a (homemade) SET?

2003-03-20 Thread Benjamin Pflugmann
Hi. On Thu 2003-03-20 at 15:52:25 +0100, [EMAIL PROTECTED] wrote: > > I use a lot of SET-alike fields in my tables. The fields are used to store > properties and such; every bit stands for a specific value. The fields are > queries like 'where property_field & 1<<4' or 'where property_field & 102

Index on a (homemade) SET?

2003-03-20 Thread harm
Hello, I use a lot of SET-alike fields in my tables. The fields are used to store properties and such; every bit stands for a specific value. The fields are queries like 'where property_field & 1<<4' or 'where property_field & 1025' if you look for more than one property. Just your average SET be