:Comparing Cursor and Set Approaches in Processing Relational Data
Comparing Cursor and Set Approaches in Processing Relational Data Sep 20, 2008, 12 :02 UTC (1 Talkback[s]) (1922 reads) (Other stories by Djoni Darmawikarta)
"Instead of processing row-by-row sequentially, you can process relational data set-by-set, without a cursor. For example, to sum all payment rows with 100 or less balances and load it into a table (named payment_100orless_bal in the following SQL statement), you can use the following SQL statement. This single SQL statement completely processes the rows that meet the condition, all at once, as a set."