>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?

post this's time tAll:

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

then compute

Expected time = tAll*961659 /1283328