I have a merge query of below format – now I have to do union in this query My question is do I have to give parallel hint in second union clause also . Also use_hash hint which was running good earlier would not have impact on adding union clause in the query Answer The hints apply to each select