Tips and Tricks (Revision #0)

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 History	Executed 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 interaction.

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	Grid	Pivot 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 Plan	SQL 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 Edit	Editing 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 Formatting	Formatting Options	Formatted Query

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