SELECT citemno, SUM(ntrfqty2) AS Shipped FROM icitrf WHERE (dtrs BETWEEN '02/01/04' AND '03/26/04') AND (cwhouse BETWEEN 'WAL0000' AND 'WAL9999') GROUP BY citemnoAny hints at how I might optimize this? I have created indices on the obvious fields (dtrs, cwhouse and citemno) but it still takes forever to run.