if you have not done so already you can collect/update stats on the tables/columns in the join condition to better inform the optimizer.
Recent Threads
Attachments
Library
Quick Reference
Useful Links
Rules of Conduct
FAQs
Join the Forum
Archives
Sample Index
2004 Indexes