Home » » Oracle SQL Performance Tuning Tips-Using IN with MINUS in place of NOT IN for non indexed columns atz help

Oracle SQL Performance Tuning Tips-Using IN with MINUS in place of NOT IN for non indexed columns atz help

Written By M.L on ஞாயிறு, 22 ஏப்ரல், 2012 | ஏப்ரல் 22, 2012

Oracle SQL Performance Tuning Tips-Using IN with MINUS in place of NOT IN for non indexed columns atz help

In sub-query statements such as the following, the NOT IN clause causes an internal sort/merge

  select * from system_user
  where su_user_id not in
  (select ac_user from account)

wINSTEAD USE
 
  select * from system_user
  where su_user_id in
  (select su_user_id from system_user
   minus
  select ac_user from account)


Note : Provide your comments by clicking below options! Thanks ! :)

0 comments:

கருத்துரையிடுக

Popular Posts

General Category