Linux Today: Linux News On Internet Time.

Comparing Cursor and Set Approaches in Processing Relational Data

Sep 20, 2008, 12:02 (1 Talkback[s])
(Other stories by Djoni Darmawikarta)

[ Thanks to Bhushan Pangaonkar for this link. ]

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

Complete Story

Related Stories: