SQL & PL/SQL

1 error has occurred

Your session has timed out.

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Minus operator versus 'not exists' for faster SQL query

blogginsNov 14 2002

Hi everybody,

Does anyone know if rewriting a query to use the MINUS operator instead of using NOT EXISTS in the query is faster, giving all else is the same?

Thanks very much!

Bill Loggins
801-971-6837
bill@acm.org

Processing

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 13 2002

Added on Nov 14 2002

3 comments

24,086 views

SQL & PL/SQL

Minus operator versus 'not exists' for faster SQL query

Comments

Post Details