On Sun, 5 Oct 2003, Santino wrote: > Have You test in operator? > > select * from table where id in (10,20,30,50,60,90, ....)
Yes, IN does perform at the levels I want and works for the simplified example I gave, but doesn't work for the generalized case I need, which is matching individual rows in a table with a multicolumn primary key which is why I can't use it. Well, I could use it but it would require creating an extra column that is a string with all the component columns of the primary key combined or a binary field that I pack myself then have a unique index on that... but I'd really like to avoid that since this table will have hundreds of thousands of rows added a day and has half a dozen columns that form the primary key. Interestingly, the "explain" output is exactly the same for the in and the fooid=10 or fooid=20 or ... case. thanks for the suggestion. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
