>>What is the PK of the table?
>
>Thread.Numero is the primary key.
>
>>You may try
>>
>>select Thread.AddDate,Thread.Numero,Thread.Title,Thread.Url from Thread (NOLOCK)
>>inner join (select top (10) Numero from Thread (NOLOCK)
>>WHERE Thread.NoMember=@NoMember AND Thread.AddDate>@AddDate
>>ORDER BY Thread.Numero DESC) X on Thread. Numero = X.Numero
>
>Thanks, by doing this, I obtain the new execution plan. See attached. By interpreting that, does this mean this new execution plan is more optimized than the previous one?
Did you try running both queries and see how much in % to total time each query cost? The Key Lookup seems to be the slowest one. What indexes do you have in your table? May be we need one with Numero and include Column AddDate ?
If it's not broken, fix it until it is.
My Blog