|
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's |
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 Tables are also
available
 |
 |
 |
Enable Grids/ Pivot Grids
|
Grid |
Pivot Grid |
Using the Keyboard combination
"CTRL+ALT+H", you may quickly view the SQL Historyy
Tip 3 : You can enable Execution Plan in Aqua Data Studio 7.5
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 7.5
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: Hit CTRL+D in a query to get the descriptions
of the tables involved in the Query
 |
| Describe |
Tip 7: You can quickly Format the SQL Queries in
the Query Analyzer
 |
 |
 |
Before Formatting
|
Options |
Formatted Query
|
Using the Keyboard
combination "CTRL+B", you
may quickly Format your SQL Query
|
