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!

Performance with IN Operator

440904Aug 7 2007 — edited Aug 7 2007
Hi All,
We have JOB table with 30K records and Dept table with 300 records , i need get list of EE's for 100 depts out of this, say NY location depts.

Is it good to have IN operator, or join both the tables and have criteria on dept table where location ='NY'.

I was thinking using IN operator, having Static list would perform better, my DBA told aviod using IN and EXISTS. I wasn't able TO understand
her explantion FOR this..

Could any one tell me..

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 4 2007
Added on Aug 7 2007
2 comments
269 views