I looked at my query again and I found out that I had an extra clause NOT EXISTS which was causing difference in speed and plans, omitting not EXISTS didn't make difference in speed in both cases.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
I looked at my query again and I found out that I had an extra clause
NOT EXISTS
which was causing difference in speed and plans, omittingnot EXISTS
didn't make difference in speed in both cases.