Any suggestions for improvement?
2015-05-18 09:35:41
2015-05-23 09:25:27
Not really. The bulk of the elapsed time (616ms) is spent waiting for the client to consume the results (567ms NETWORK_IO in the wait stats tab). You could look at avoiding the Key Lookup by including extra columns in the nonclustered index, but that might be counter-productive.