On Friday 10 September 2004 02:36 pm, Dylan Beaudette wrote: ... > EXPLAIN SELECT [a bunch of columns] > FROM UDC > WHERE UDC.year IN ('2000') AND county_cd IN ('28') AND UDC.chem_code IN > ('198'); See what happens if you use '=' instead of 'IN' (and remove the parentheses). -- Rod