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[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA