This query take about 5-8 minutes to run.

There are 1,283,328 records in the table and the query returns 961,659 records.

SELECT DocId, BoId, BoIdBase, RecType, OrdQty, Gross, StatName, ClientId, BInit,;
       WeekOf, DStat_Net, DClnt_Net,DLComm, 0.00 AS NumCleared;
  FROM LineItems;
  WHERE &cWhere;
  INTO TABLE LineTemp

The Variable 'cWhere' contains:

INLIST(BrokerId, '  ', 'MC') AND  BETWEEN(WeekOf, {01/01/1990},{12/31/2004})

There are indexes on both BrokerId and WeekOf.

Anyone?