General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only