• A fairly nasty query, I would say, that leaves the optimizer between a rock and a hard place.

    SQL Server can retrieve orders by recorddate, until it has found 10000 rows that fits criteria on ClaimID. Or it can retrieve all rows through the clustered index that fits the index and sort those rows.

    Since I don't know the statistics, I can't say which plan is the best. What I bet that ClaimID and RecordDate are correlated - something that the optimizer don't know and don't assume.

    Since your aim is to test the hardware, drop the issue about the different plans, but add an index hint so that you get the same plans on both platforms.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]