SwePeso (9/2/2010)

---

This line seems to be obselete, unless it's used for filtering? It is not used in the resultset.

INNER JOIN ltf.sforce.Contact AS ReferrerContact ON ReferrerContact.Id = Prospect__c.Referring_Member__c...

Grant Fritchey (9/2/2010)

---

Your estimated & actuals are a bit off, especially at the end of the query. Are your statistics up to date?

...I'd expect to see hash joins for all...

Thanks for the suggestions. I have a question about #2. I...

Definitions and queryplan are attached.

The query you added does work, however you have taken the value of the fn column out of the database and directly into the sql statement.  If the data in...