• Although you have gotten me wondering if I shouldn't add a non-clustered index on StartDate (in the Clients table)...

    To solve this problem? Probably not.

    If its really a 200 row table indexing is not likely to be the issue, and I believe you need all the rows from Clients anyway, so Luis' query would not use it.