5.8 Tips and Tricks

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.

Tip 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

Tip 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

Tip 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", you may quickly enable the Execution Plan

Tip 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", you may quickly enable the Visual Query builder

Tip 5:  With Execute Edit feature in Aqua Data Studio you can quickly edit data from a table

Enable Execute Edit	Editing Table Data

Using the Keyboard combination "CTRL+ALT+Enter", you may quickly start editing Table Data

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

Table Describe

Tip 7: You can quickly Format the SQL Queries in the Query Analyzer

Before Formatting	Formatting Options	Formatted Query

Using the Keyboard combination "CTRL+B", you may quickly Format your SQL Query