Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Select with MINUS vs Two VARRAYS with MULTISET

892227Apr 2 2012 — edited Apr 3 2012
Hi All,

I just wanted to know, which one of the following two is more faster and results in better performance.

1. SELECT statement containing 200+ columns from one Table with MINUS operator. (TWO SELECTS with MINUS operator between them)

2. Loading the Individual SELECT statement's (with out MINUS) result sets into two different VARRAYS and then use MULTISET operators on those two.

Which one is faster and uses less memeory ?

Thanks
Raj
This post has been answered by SamFisher on Apr 2 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2012
Added on Apr 2 2012
#performance, #sql
8 comments
521 views