I am an old MS SQL server guy and I am doing some work in oracle 10G. Most of what I am doing is all set manipulation(insection between two dataset) My first instinct would be to use temporary tables and use a not exists.
I was wondering if that is the most efficient way in oracle. I read about bulk collections but once you have the data in a collection, the access still seems to be row by row.
For algorithms I can state as set manipulation, it is better to use tables or is that just an MS bias.
thanks for your comments
August 22, 2008 2:51 PM
September 11, 2008 3:29 PM