Lynn Pettis (9/13/2012)

---

What would really help us help you is if you would provide the DDL (CREATE TABLE statement) for the tables involved including the indexes currently defined on the tables. Some sample data (as INSERT INTO statements) for the tables, and the actual execution plan for the query (if possible) as a .sqlplan file.

Right now, you are getting some help, but basically just shots in the dark.