• doesnt appear to really have helped....attached is the new sqlplan.

    also my indexes do NOT have much fragmentation..I do a reorg every other day and rebuild once a week.