8.2.35 setHADBSQLHashFltSize(int areaSize)
- Organization of this subsection
(1) Function
This method sets for this Connection object the size of the hash filter area.
The value set by this method is compatible with the adb_sql_exe_hashflt_area_size operand in the client definition.
- Important
-
For the Statement or PreparedStatement object generated from the Connection object for which this method is specified, the size of the hash filter area that is set by this method is applied until the Connection object is closed.
For details about how to use this method (how to change the size of the hash filter area for each SQL statement to be executed), see (7) Examples in 8.2.37 setHADBSQLMaxRthdNum(int rthdNum).
(2) Format
public void setHADBSQLHashFltSize(int areaSize) throws SQLException
(3) Arguments
- int areaSize
-
Specifies in megabytes the size of the hash filter area to be set.
(4) Return value
None.
(5) Exceptions
The JDBC driver throws an SQLException in the following cases:
-
The Connection object is closed.
-
An invalid value is specified in areaSize.
(6) Notes
-
This is an HADB-specific method provided by the AdbConnection interface. For details about the execution method, see 12.2 Wrapper interface.
-
For the size of the hash filter area specified by using the setHADBSQLHashFltSize method, the previously set value is not inherited if the Connection object is pooled and then reused. This is the same case as when the setHADBSQLHashFltSize method has not been executed.
-
Even if the setHADBSQLHashFltSize method is used to set the size of the hash filter area again, the new setting is not applied to the Statement or PreparedStatement object that has already been generated.
-
For details about how the size of the hash filter area is determined, see the explanation of the operand adb_sql_exe_hashflt_area_size in 2.2.3 Operands related to performance.