Topic
1 reply Latest Post - ‏2012-12-18T09:38:42Z by SystemAdmin
Tom_Glaser
Tom_Glaser
6 Posts
ACCEPTED ANSWER

Pinned topic Can Data Studio V3.1.1 explain the entire plan_table?

‏2012-10-02T17:25:03Z |
Hi,

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.

Thanks,

Tom Glaser
Updated on 2012-12-18T09:38:42Z at 2012-12-18T09:38:42Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    1632 Posts
    ACCEPTED ANSWER

    Re: Can Data Studio V3.1.1 explain the entire plan_table?

    ‏2012-12-18T09:38:42Z  in response to Tom_Glaser
    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.