Higher Performance Cursors

In that priorexample I used a cursor technique that might be alien to some -rather than using a DECLARE CURSOR, I iterated through the recordsby id.

I came across this at one shop that I did some consulting. Atfirst I approached it with skepticism – It seemed like anunnecessarily quirkly way of doing a cursor – but afterseveral benchmarks I was sold. If the iterating id is indexed(which it often is), the performance advantage will vary betweenmarginal to significant.