• Some comments:

    1) You're bringing back a LOT of data. Compare the run times just bringing back a pkey or whatever, you'll see the difference. If you have to have it, you have to have it, but I'd look for ideas to trim some.

    2) Qualify the tables with the owner - ala dbo.tablename. You'll gain a bit. Not a lot, but every bit helps.

    3) Consider using either NOLOCK or setting isolation mode to read uncommitted if you can stand it.

    4) Placement of the clustered index seems ok at first glance.

    Andy

    http://qa.sqlservercentral.com/columnists/awarren/