0
The following query is taking over 800ms to run, and returning 300 rows.
SELECT
Tests.Id,
Tests.Title,
Tests.AuthorId,
Tests.[Status],
Users.FirstName + ' ' + Users.LastName AS AuthorName,
(SELECT
COUNT(1)
FROM Results LEFT JOIN Users ON Results.UserId = User...
