12.1. Host Group Management
Host groups can make hosts display clearly when where are lots of hosts needed to manage.
Hide or Show Groups
Users can choose hide or show the host group by menu as follows:
Open Groups Settings Dialog
Use Group Settings… above to open the group management dialog as follows:
Add, Edit Group Nodes of Hosts
Button Add will open a new group dialog to let users input the new group's name and children hosts.
Left area of the dialog is a list of current hosts which is not in current group and right area is a list of current group’s children hosts.
Select a group to be deleted and push the button Delete.
Note: the Default Group can not be deleted and edited, it store the hosts which is not in other groups.
Users can drag several host nodes to another group node or change the display order of host nodes of current group node.
Users can also change the display order of host nodes when group nodes are hidden.
12.2. Configuring Background Operations in Multiple-Host Environment
If you manage databases in several hosts by using Add Host, databases can be configured for background operations. For example, if you want to execute a query to a database in host B while doing backup for a database in host A, the database backup operation, which generally takes a long time, can be configured to be executed as a background operation. The database operations that can be run in the background are as follows:
12.3. OID Navigator
It is used to search data by OIDs.
You can run the OID Navigator by right-clicking a database or inside the Result pane of the Query editor and then selecting OID Navigator. Note that this function is activated only while the database server is running; this is deactivated while the server is not running.
12.4. Query Tuner
The query tuner is used to develop the high performance SQL. You can tune the query and compare the performance between different queries. There are consists of two parts as "Tune a query", "Compare a query plan".
12.4.1 Tune a query
You can edit and run a query in order to get a query plan and a statistics when it runs. And also you can save the query plan result in order to compare other query plans.
(1) The toolbar for query:
(2) The query editor: You can edit the query in this pane.
(3) The query result table: To display the result data.
(4) The toolbar for query plan:
(5) The query statistics table: To display current and last query statistics.
(6) The current query plan panel: This panel to display current query plan.
(7) The last query plan panel: This panel to display last query plan.
(8) Query project toolbar: To manage the query project.
12.4.2 Compare a query plan
As mentioned above, you can compare two query plan in order to get what is a different. You can compare queries, plans(there also supports graphical query plan).
(1) To select left query plan.
(2) To select right query plan.
(3) To display the query statistics.
(4) To display left selected query plan.