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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!