Alternative execution plan for the SQL
Hi All, I have a below query which is performing very badly. I ran the SQL Tuning advisor which gave me the better execution plan. I ran the accept_sql_profile for query to accept the new plan but still my query is using the old plan. Query is running in the background and i am trying to change the execution plan dynamically.
RECOMMENDATIONS
----------------------------------------------------------------------------------------------------
GENERAL INFORMATION SECTION
-------------------------------------------------------------------------------
Tuning Task Name : 38fzp0r4mbbmc_TUNING_TASK1
Tuning Task Owner : SYS
Workload Type : Single SQL Statement
Scope : COMPREHENSIVE
Time Limit(seconds): 180
Completion Status : COMPLETED
Started at : 06/07/2017 14:46:31
Completed at : 06/07/2017 14:47:21
-------------------------------------------------------------------------------
Schema Name: GPPSCH