>No, with order by clause it will have to create result set first, order it and than pick TOP N records from it. The same way it works in VFP.
Well, as my result is the first most recent, thus the last 10 in the table which matches the condition, it means that no matter if that would be in Visual FoxPro or in SQL Server, it'll take some time.