Below are tips for quickly using common functions of the Query Analyzer. More information about each tip is discussed in the documentation page relating to the menu item or shortcut key for that feature.

  1. You can easily view the archive of SQL Statements executed in the Query Analyzer by enabling the SQL History. The ’Start Date/Time’ and ’End Data/Time’ columns show the time the query started and ended execution.

    SQL HistoryExecuted SQL

    Using the Keyboard combination CTRL+ALT+H you may quickly view the SQL History. To view even more detailed information on the queries that Aqua Data Studio executes during its use, launch the SQL Log to record all SQL interactions.

  2. You can enable Charting Tool in the Query Analyzer and get a graphical representation of your data. Pivot Grids (Pivot Tables) are also available

    Enable Grids
    Pivot Grids    		GridPivot Grid

  3. You can enable Execution Plans in Aqua Data Studio which offers insight into the execution of SQL Statements and helps the user isolate potential performance bottlenecks

    Enable Execution PlanSQL Execution Plan

    Using the Keyboard combination ALT+F11 will enable the Execution Plan

  4. Build SQL Query - The Visual Query Builder allows users to graphically select tables, views, and relationships to build queries

    Query Builder

    Using the Keyboard combination CTRL+ALT+Q will enable the Visual Query builder

  5. With Execute Edit feature in Aqua Data Studio, you can edit data from a table

    Enable Execute EditEditing Table Data

    Using the Keyboard combination CTRL+ALT+Enter will start editing Table Data

  6. Type CTRL+D in a query to get the descriptions of the tables involved in the Query

    Table Describe

  7. You can Format the SQL Queries in the Query Analyzer

    Before FormattingFormatting
    Options    		Formatted Query

    Using the Keyboard combination CTRL+B will quickly Format your SQL Query