Thanks Chris. And sorry I forgot to mention that I've followed your first reply and compared the explains and they are identical. Then I checked the column on my 2 tables and both are not null...

I guess may be I could ask the developer to add some more criterion on the first table would reduce the cost?