I think I read somewhere, and want to confirm, that if I use a hint on a JOIN statement, that hint takes precendence on ALL JOINS. Thus if I state:
SELECT * FROM A MERGE JOIN B ON A.col1 = B.col1 JOIN C ON A.col1 = C.col1 JOIN D ON A.col2 = D.col2
then ALL JOINS are MERGE JOINS. Is that true? If so, by default, then can I supply a different type of HINT on any of the other join statements, thus state:
SELECT * FROM A MERGE JOIN B ON A.col1 = B.col1 JOIN C ON A.col1 = C.col1 HASH JOIN D ON A.col2 = D.col2
And if I can do that, do 'subsequent joins take the same hint as predecessors, or am I completely off on all my suppositions.
Before you go off on me as to why hints should not be used, I am with you, and am trying to gather information in support of why they should not be used.