ekant,
If you continue to get stuck, one of the things that will help us the most is the .sqlplan. If you take a look in my sig, there's a link to an article that'll walk you through what you really want to get us for the best support. It's the index/tuning link.
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