• The execution time is the same? I'm not surprised the reads are the same. You're still scanning 45,000 rows.

    There just isn't anything to tune in the query here.

    Wild shot in the dark, maybe if you set up a filtered, nonclustered index on the same key column as your cluster, filtered for 'RESO' and use the three columns from the output as INCLUDE. You'll still get an index scan, but it might be a smaller number of reads since you'll possibly have more data per page (maybe, can't see the rest of your structure). I'm not sure that will help at all.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning