Any suggestions for improvement?

olafjo 2015-05-18 09:35:41

SQLkiwi 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.