| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Christopher Thompson | Date: | August 21 2000 9:40pm |
| Subject: | Fastest way to select sets | ||
| View as plain text | |||
If I have a set with 10 items in it and I want to select a record if one or more of the items are found, what is the fastest way to do this? Is it better to create 10 TINYINT (or CHAR(0)?) fields and do "WHERE field1=1 OR field3=1". Or, is it faster to use the SET field type? Or, some other way?
| Thread | ||
|---|---|---|
| • CHAR vs VARCHAR | Claude Cormier | 21 Aug |
| • Re: CHAR vs VARCHAR | Rob McMillin | 21 Aug |
| • Re: CHAR vs VARCHAR | Claude Cormier | 21 Aug |
| • RE: CHAR vs VARCHAR | Sander Pilon | 21 Aug |
| • Re: CHAR vs VARCHAR | Kris Dahl | 21 Aug |
| • Re: CHAR vs VARCHAR | Jan Dvorak | 21 Aug |
| • Re: CHAR vs VARCHAR | Kris Dahl | 22 Aug |
| • Re: CHAR vs VARCHAR | Ed Wang | 21 Aug |
| • Re: CHAR vs VARCHAR | Kris Dahl | 21 Aug |
| • RE: CHAR vs VARCHAR | Christopher Thompson | 21 Aug |
| • RE: CHAR vs VARCHAR | Dana Powers | 21 Aug |
| • Re: CHAR vs VARCHAR | Steve Ruby | 21 Aug |
| • Fastest way to select sets | Christopher Thompson | 21 Aug |
| • Re: Fastest way to select sets | Steve Ruby | 22 Aug |
| • Re: Fastest way to select sets | Tonu Samuel | 22 Aug |
| • Re: Fastest way to select sets | Tino Hendricks | 28 Aug |
| • Re: Fastest way to select sets | Tonu Samuel | 2 Sep |
| • Re: CHAR vs VARCHAR | Paul Schmidt | 22 Aug |
