I have a SQL Query that takes some time to return answer. Is there a way to speed up the response?
The table has about 5,000,000 rows of data.
SELECT vol FROM tblVolDelta13_18 WHERE [deltaId] = '50' and [loadTime] = '25200' and [expiryId] = '2' and [loadDate] = '40623'
Generally, the idea is to retreive the vol data for the latest date. Running this query does take about 30 seconds to retreive the answer.