Improved Performance: - Our internal testing has revealed
that, in an overwhelming majority of cases, set processing performs
significantly better than it is -by-row counterpart for “reasonable” batch
processing volumes.
Minimized SQL Overhead: - It tends to use fewer Application
Engine SQL statements that each processed more data than the statements
executed in row-by-row processing.
Easy Maintenance: - if need to make a fix or add an
enhancement to SQL, it’s just a matter of modifying the SQL or inserting the
new “Chunk”.
Leveraging the RDBMS: - With Set – based processing, you
take advantage of the SQL processing engine on the database rather than placing
the processing burden and overhead on the application executable.
