Query Builder

Build Complex Queries

Graphically compose complex queries.

Choose Columns Using Checkboxes

Choose the columns to be listed in the query using checkboxes.

Add Cascading Child Table

Click the Foreign Key icon on the right of the column name to add a table to query based on this Foreign Key.

Change Join Type

Click the Foreign Key line to change the Join condition to INNER JOIN, LEFT OUTER JOIN, EXISTS, NOT EXISTS.

Filter Table Data

Add WHERE conditions to the query by right-clicking a column.

Create Group By Queries

By adding one of the SUM(), AVG(), COUNT(),... functions to your query, the query will make use of the GROUP BY clause.

Use Multiple Result Panes

Like for SQL Editor you can have multiple result panes.

Spool Result To File

In the Result Pane you have the option to save the result to file. You can also enter the spool mode, which is useful for large results. In this case the result won't be displayed on the screen, but pushed directly to a file you will choose. The advantage is that the result won't be paged, as on the screen, but completly written to file..

Explain Query Execution Plan

This feature is being implemented only for some of the databases. Using it you have a better representation of the query execution plan tree. On the left you can see the original execution plan, as delivered from the database. On the right is the time-line representation of the plan, so you can see which step is executed at which point in time.