But if we have LEFTor RIGHT JOIN as below,is it possible to improve something at this case?

SELECT pr.column1,

pr.column2

FROM PlayersTypesAS pr WITH(NOLOCK)

INNER JOIN dbo.Players AS p WITH(NOLOCK) ON p.PlayerTypeID = pr.PlayerTypeID

LEFT...

Thank you all !

We have an index on PlayersRestrictionID, but not clustered

We saw that it improves performance.

Why not? Making join usually takes more resources and time then simple select.

Thank you!