 <p>Does it help when you force the time filter to kick in only after the client filter has run? </p> <p>FI like in this example:</p> <pre><code>;WITH ClientData AS ( SELECT [E2].[CompanyId] ,[E2].[Time] ,[E1].[Id] ,[E1].[Status] FROM [dbo].[SplittedSms] AS [E1] INNER JOIN [dbo].[Sms] AS [E2] ON [E1].[SmsId] = [E2].[Id] WHERE [E2].[CompanyId] = 4563 AND ([E1].[NotifiedToClient] IS NULL) ) SELECT TOP 10 [CompanyId] ,[Id] ,[Status] FROM ClientData WHERE [Time] &gt; '2015-04-10' </code></pre>