Baseline created with a different explain plan for the same qurey.
HI Oracle Gurus,
I am facing an issue where I am in process of migrating schema from one database 11.2.0.2 to new database 11.2.0.4. One sql is using different plan.
I thought of creating a baseline plan but When I create the baseline it in using a different plan that with what it is running. Can you please suggest. I am copying my results here.
First I am checking the plain what my query is using with display_cursor. It gives me the desired plan.
But When I create the baseline with same sql_id it creates the baseline with a different plan which show more CPU time. Problem is with step 11 where it is doing a full table scan instead of Index scan as shown is current execution plan. I marked the step 11 in bold. Please let me know your thoughts on this.