Thanks for response. In my case issue was with encoding type of the script used, once converted to utf-8 and deployed issue was solved.

Hasini...

Thanks for the detailed reply.

I am running both the quries at the same time and also doing DBCC DROPCLEANBUFFER and DBCC CLEARPROCCACHE before for both the queries.

If this is a...

I have 2 queries

SELECT * FROM Table1

JOIN Table2

ON Table1.Column1 = Table2.Column1

SELECT * FROM Table1

JOIN Table2

ON Table1.Column1 = Table2.Column1

AND Table1.Column2 = XXX

Both these query returns same number of results say 7000....