Would need, at the least, to see the .sqlplan and the tables/indexes. Check out the second link on the left side of my signature for all the pieces that would allow us to really help you (Index/tuning help).
- Craig Farrell
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake. For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally TablesTwitter: @AnyWayDBA