>>the logic of the query selects records for an individual employee (by id number) after a specific date. Employees have a record for each pay so there are multible records for each employee id in the file.
>>
>>I had thought about bringing the table into the project and setting up an index on employee id to help the query but the improvement was zero.
>>
>>Can anyone suggest a strategy?
>
>Have you tried with another index on the date?


Addning the index on date increased performance to the 1 second range. Thanks.

CG