Identifying row-by-row queries?

• Ted Manasa

  Default port

  Points: 1461

  More actions

  August 27, 2008 at 3:03 pm

  #197584

  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 >>

• GSquared

  SSC Guru

  Points: 260824

  More actions

  August 27, 2008 at 3:16 pm

  #864009

  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