re: Improving SQL Query by Adding conditions in Joins VIEW POST

TOP OF THREAD FULL DISCUSSION
re: Plans have obviously have to be different. I see this is SQL Server and it will cache plan for an exact query you run. By moving date time clause ...

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.

code of conduct - report abuse