>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 -- Assuming Numero is a PK

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?