Hi

You have an existing index

CREATE NONCLUSTERED INDEX [IX_Player_partnerIddtCreated] ON [dbo].[Player]

(

[partnerId] ASC,

[dtCreated] ASC

)

INCLUDE ( [playerId])

If you take a look in your execution plan you'll see a missing index. You can create it, but it's wiser if you could extend the already existing one [IX_Player_partnerIddtCreated] with the following definition:

CREATE NONCLUSTERED INDEX [IX_Player_partnerIddtCreated]

ON [dbo].[Player] ([partnerId] ASC,

[dtCreated] ASC)

INCLUDE ([playerId],[partnerId],,[alias],[forename],[surname],[firstGame],[firstMoneyGame])

Tables are not big so you have a performance issue.

Regards,

IgorMi