I'm looking for the right panel that will allow me to explain the SQL statements in a plan_table (and hopefully packages). Is this option available in this version? I could find it in V2. I can find something called Query Tuner Workload Assistant and it specifies "Plan Table." However, when I click on the button "Capture Query Environment," it comes up with a panel stating "Specify the SQL statement that you want to send to the IBM support," which is not what I'm wanting to do.
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
1 reply Latest Post - 2012-12-18T09:38:42Z by SystemAdmin
Pinned topic Can Data Studio V3.1.1 explain the entire plan_table?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-12-18T09:38:42Z at 2012-12-18T09:38:42Z by SystemAdmin
SystemAdmin 110000D4XK1632 PostsACCEPTED ANSWER
Re: Can Data Studio V3.1.1 explain the entire plan_table?2012-12-18T09:38:42Z in response to Tom_GlaserHi Tom Glaser,
Firstly I want to confirm your question: "Can Data Studio V3.1.1 explain the entire plan_table".
Would you please just to explain one query and view the records in the plan_table by Data Studio V3.1.1? Since the "Plan Table" tab in Query Tuner Workload Assistant is used to capture query from PLAN_TABLE,not explain query.