When do I use a collection instead of a table
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
Keith
Software/Hardware used:
Software/Hardware used:
ASKED:
August 22, 2008 2:51 PM
UPDATED:
September 11, 2008 3:29 PM
RELATED QUESTIONS
Answer Wiki:
I have not used collections in version 10g, but as far as I know, you cannot make comparisons between two complete collections, so, for what you want to do I think it would be a better approach to use temporary tables.
Collections can be really useful, but it depends on what you want to accomplish.
An interesting article on collections is <a href="http://www.dba-oracle.com/oracle_tips_rittman_PLSQL_performance.htm"> here.</a>
Regards,
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
