Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Type = Query – Lets you scroll through queries that were executed based on your filter selection. 
  • Type = All - Let's you scroll through a list that contains queries, DDL, and utility statements. This works similarly to the query list described above. However, this list also contains DDL and utility statements and there is no execution plan for them. You will notice that when you select one of these the “Execution Plan” tab disappears. The execution plan tab is only available for queries.

    In the case where visual explain is executed, an explain plan grid with detailed summarized information about each step in the query process will be displayed. This plan grid should be read from the bottom up. When you right-click on this grid, a pop-up menu will show you some other options that are available such as an explanatory diagram. Clicking the “Explain Diagram” shows a block hierarchical diagram of the steps for executing this query.
  • Type = Utility or DDL – This does not apply since there are no queries in these lists.

     


  
 
 
 
 
 
Last updated by nhilam on Sep 16, 2021 4:09 PM
Comments (0) Attachments (12)
Sort 
This list is empty.
 to comment on wiki pages on AquaClusters. Already have an account? Sign in to participate