Hi,
In SQL query we say avoid to use of NOT Exist this is because of if we have index on our table then because of NOT Exist our query will not take the benefit of index. We can avoid the use of not exist using the below query.
In SQL query we say avoid to use of NOT Exist this is because of if we have index on our table then because of NOT Exist our query will not take the benefit of index. We can avoid the use of not exist using the below query.
In the above image i have shown the example of NOT EXIST and How to replace the NOT EXIST with LEFT JOIN.
Thanks,
Rahul
No comments:
Post a Comment