1. Set based processing will likely be much faster than row based processing. Our experiment of processing 100K rows showed row based processing was 3700 times slower than set based processing. Not twice as slower or even 10 times slower… 3700 times slower!
2. Compared to set based processing, row based processing times degrade much quicker than set based processing. That is, row based processing does not scale nearly as well as set based processing. We saw this in that the linear trend line for row based processing was 0.00259 compared to 0.00000 for set based processing.
- Oracle versus IBM and DB2
- Rename column or constraint in Oracle
- How The Oracle Database Processes SQL Statements
This article was syndicated via RSS from: http://feedproxy.google.com/~r/EddieAwadsFeed/~3/kZkz6rCE0u8/row-versus-set-processing-surprise.html