LOL, I should have looked up what re-entrant meant before answering. Oops. 🙂 That'll learn me.
I wasn't thinking in terms of multiple connections, but the same connection re-entering its own query plan. Oopsies. 😀
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