I do not know. Do you have any missing indices? Are they same on both tables? Do you have a lazy good fer nuthin' DBA hanging around? Does DBCC SHOWCONTIG show a high level of fragmentation on those indexes? Do both machines run similar hardware? Do both machines contain similar amounts of data? Yes, post the text version of the execution plan.