What Are The Advantages Of Set Processing?

1.	What Are The Advantages Of Set Processing?
Answer» Improved Performance: – 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.

Answer»

Improved Performance: – 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.

Discussion