jwcolby
jwcolby at colbyconsulting.com
Wed Nov 21 15:04:53 CST 2007
I have a lot of queries where I have to look for multiple values. I have been using an IN() clause but I am advised that is very slow. OTOH I built two queries that use an IN() in one query and a bunch of ORs in the other and over a 56 million record table they were both so fast I couldn't see the difference (Indexed column, containing values 1-9 and A-T (under 2 sec) Any comments? John W. Colby Colby Consulting www.ColbyConsulting.com