August 27, 2008 at 3:03 pm
Is there any deterministic way to check whether your query is set-based or performing row-based operations?
We have seen situations in which we thought we'd written set-based queries, but they seem to perform like row-based ones.
I would imagine you would see a tell-tale sign in showplan_all but I haven't been able to find it.
Thanks a lot.
---------------------------
|Ted Pin >>
August 27, 2008 at 3:16 pm
The execution plan will sometimes give it away, but the best way I know of to tell is to look at the code and see what it's telling SQL to do.
Look for cursors, while loops, inline functions, inline subqueries, etc.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply