Let me tell you, i do know using hints should be the last option. I am really in a situation where i need to address a issue by hook or crook ( actually most of my issues are addressed like this :hehe
. I have a left join which is executing for each record, i looked in the exec plan and it is using a Nested loop. My goal was to have it execute ONLY once, so i replaced with left hash JOIN and this made it execute only once and made query much much faster. My question is would this type left hash JOIN ever NOT GIVE the same result as LEFT Join.