When do I use a collection instead of a table in Oracle

5 pts.
Tags:
Oracle 10g
SQL
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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 here.

Regards,

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following