Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 | 

Query Editor Options

The Query Editor's options can be set in the following way. Options are applied according to the following priority.

How To

Priority

Description

[File] > [Preferences] > [Query options]

3rd

Basic information of the current CUBRID Manager. Default values that are applied last when there no values applied to each host and database.

[Host] > [Properties] > [Query]

2nd

It is applied prior to [File] > [Preferences] and commonly within the host.

[Database] > [Properties] > [Connection Information]

1st

It is applied prior to [Host] > [Properties]. Information such as the connection port and the character set can be specified. This information is applied to the Query Editor subsequently opened after the modification.

[File] > [Preferences] > [Query options]

Sets the basic information about the currently used CUBRID Manager. Provides the same items as the host setting.

[Host] > [Properties] > [Query]

manager_queryeditor_option_host.png

In the [Query] dialog box, you can set the following options:

  • Autocommit : You can set a default value so that autocommit is performed after a query is executed in the query edit pane. Even when [Autocommit] is selected, you can set (icon_autocommiton.jpg)/clear (icon_autocommitoff.png) the function from the toolbar in the Query Editor.
  • Search unit of result instances : Sets the number of result rows to be fetched at once from the database after the execution of the query. That is, if the number of search result rows is 7,000 when the value is set to 5,000, you can select whether or not to continue to fetch more search results after 5,000 rows are fetched. In addition, if you execute queries that satisfy the following conditions, ROWNUM is automatically added based on the set value to prevent using excessive server resources.
    • WHERE condition is missing.
    • GROUP BY is not used.
    • ORDER BY is not used.
    • Aggregate functions (SUM, COUNT, MIN, MAX, AVG, STDDEV and VARIANCE) are not used.  
    • Hierarchical Query is not used.
  • Page unit of result instances : You can navigate in the query results pane by paging (icon_first.pngicon_previous.pngicon_next.pngicon_last.png) specified number of records.
  • Enable query plan : You can check the query plan before and after its execution. Selecting this option may slightly affect the query execution time because plan information will be created in advance for queries to be executed.
  • Get OID info : Fetches OID information during the query execution. This allows you to directly modify/delete data in the query results pane. However, “NONE” is displayed if the OID cannot be fetched as with Join queries. Selecting this option may extend the query execution time.
  • Character set : You can set the default character set which is used in the host. The default is one used in the system where the CUBRID Manager is running.
  • Change font & size : You can change fonts and their sizes to be used in the Query Editor.
[Database] > [Properties] > [Connection Information]

manager_queryeditor_option_db.png

  • Broker IP : By default, the Broker address for the database connection is set to the IP address of the database server. If the Broker server is not connected, you can connect to the Broker by modifying this value. The Broker address can be modified only by the CUBRID Manager admin user. Other users can connect only through the Broker address specified by the admin user.
  • Broker port : A Broker port to be used for database connection. The port is displayed by the CUBRID Manager admin user. The Broker port can be modified only by the admin user. Other users can connect only through the Broker port specified by the admin user.
  • Character set : You can specify the character set for each database. It is recommended to use only one character set for a database. The default is one used in the system where the CUBRID Manager is running.