title: how to change oracle explain plan for sql query manually
body: <p>I have a oracle sql query and it has access plan attached to it. How can i change the access plan without changing the sql query. I think oracle has database table that store sql id and plan id , updating the plan id to new plan id will force the sql query to use different explain plan.</p>
  
  <p>I am using Oracle 10, In this case i don't want to touch the existing query. I will write another query with hints and get the desired explain plan created. now I will use the new marker for the explain plan and attach it to the original sql id. This is the logic how to do this, but i dont know what all tables need to be updated to achieve this. Step1 : SQLI_D1 -> PLAN_ID1; Step2 : SQL_ID2 -> PLAN_ID2; STep3 : SQL_ID1 - > PLAN_ID2</p>