Drop-down Query menu provides additional features to enrich your working experience in SQL editor. 



Here is the list of all the functions you can access via Edit menu.

   1.  Execute  - Executes the current query. A semicolon is used as the query delimiter 

   2.  Explain - opens up Explain window. This feature provides you with detailed execution plan on the selected query. There are three tabs in the window: Query - shows the query under examination. Explain - explains how the query is going to be executed. And Explain Analyze  - actually executes the query and then provides statistics and detailed explanations of the execution.

   3.  Select Query at cursor - selects query at cursor in SQL editor up to semicolumn symbol.

   4.  Complete Code Snippet - allows for code snippets to be used in the SQL editor. For more details on code snippets, please refer to Tools >> Options >> Code snippets section.

   5.  Execute all - executes all the selected queries or all the queries if there is no selection in the active SQL editor window.

   6.  Execute as Single Batch - executes the selected text as a single batch—without splitting it into individual SQL statements separated with a semicolon; executes all the text in the active SQL editor if there is no text selected. It simply submits the whole text batch to Greenplum for processing.

   7.  Execute in Selected Databases - prompts for a list of databases to execute the active or selected statements in.

   8.  Execute with SPU Utilization monitor -

   9.  Add New SQL Editor - adds new SQL editor tab to query analyzer. 


The rest of the options allow for quicker navigation between different parts of the application.

 10.  Go to Tree - moves the cursor to the object's tree in the object browser. 

 11.  Go to Query - moves the cursor to the current SQL editor.

 12.  Next Query Tab - opens next tab in the SQL editor.
 
 13.  Prev Query Tab - opens previous tab in the SQL editor.

 14.  Word wrap -  forces your text to wrap within the query text editor.

 15.  Current Query Options - brings up options for currently active SQL editor's tab. From here you can turn off/turn on syntax highlighting. You can also set the time limit for query timeouts, this is in seconds.








Go up  |  Go To WorkBench Help page