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

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 ! :)

Tweet