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.
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 Posts
Re: Can Data Studio V3.1.1 explain the entire plan_table?2012-12-18T09:38:42ZThis is the accepted answer. This is the accepted answer.Hi 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.