Page is a not externally linkable
brotherhood_of_LAN - 11:45 am on May 29, 2003 (gmt 0)
Have you tried these queries on a large table yet? If no maybe you could setup a table and fill it with junk values and see which one is quicker. Wouldn't mind knowing myself - I didnt know about the "in" syntax before you posted it here- and looks like it's what I'm after. When querying a CHAR column with a few dozen "ORs" in the WHERE clauses was quite slow for me, slower than doing them singly.....at a guess I'd hedge my bet with the "IN" query being faster.
Nick,