>I have the following query:
>
>

>DECLARE @NoMember Integer
>DECLARE @AddDate DateTime
>
>SET @NoMember=1
>SET @AddDate='2009-02-18 18:47:00'
>
>SELECT TOP 10 Thread.AddDate,Thread.Numero,Thread.Title,Thread.Url
>FROM Thread (NOLOCK)
>WHERE Thread.NoMember=@NoMember AND Thread.AddDate>@AddDate ORDER BY Thread.Numero DESC 
>

>
>The execution plan gives as attached in this message.
>
>At the bottom, there is a 97% of the process. This query, despite the fact that it returns only 10 records and despite the fact that everything is indexed, can take up to 1 to 2 seconds to execute. That is way too long. This should be done instantly. By looking at the execution plan, how would someone knows exactly what to do to optimize this?

What is the PK of the table?

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