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
Note : Provide your comments by clicking below options! Thanks ! :)
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:
கருத்துரையிடுக