• Gail - I wanted to clarify that I wasn't waiting on a second opinion, I was waiting on another round of feedback from your...

    Attached is the execution plan in 3 files because the entire plan would not save as a single file for some reason. I have created the clustered index and ran the query again with a result of 14 seconds query return time. That's 11 seconds better than before. 121000 rows returned of a possible 8 million.

    Demetrius