Skip to Main Content

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!

Alternate for not in clause

548849Nov 8 2008 — edited Nov 9 2008
Hi All,

i have query which has a query with not in clause...like this:

where column_name not in ('value1','value2',.....)

This is causing a performance hit.

Is it possible to use not exists clause?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 7 2008
Added on Nov 8 2008
1 comment
322 views