Improve select query performance
3
votes
1
answer
957
views
The following select query from my application is taking more than 200ms. The table has around 2 million rows. Is there any ways to improve the performance of this query ?
select count(id) from table1 where status='A' and empID=123
Table Indexes
PRIMARY KEY (
id
),
KEY empID
(empID
),
KEY status
(status
),
KEY testID
(testID
),
CONSTRAINT fk_1
FOREIGN KEY (empID
) REFERENCES emp_info
(id
)
Asked by IS_EV
(181 rep)
May 27, 2014, 07:56 AM
Last activity: Aug 4, 2014, 06:10 PM
Last activity: Aug 4, 2014, 06:10 PM