10.2.13 Operands related to SQL optimization

51) PDSQLOPTLVL SQL-optimization-option-for-foreign-HiRDB[,SQL-optimization-option-for-foreign-HiRDB]...
[Figure]<identifier or unsigned integer>
Specifies the SQL optimization option for a foreign HiRDB. For details on SQL optimization, see the HiRDB Version 8 UAP Development Guide. If the HiRDB version number of the foreign server is different, see the manual for the correct version.
If this operand is omitted, the SQL optimization option that is set by the foreign HiRDB is applied. Specify this operand when the SQL optimization option of the foreign HiRDB is not to be used.
Operand rule
The maximum length of the character string that can be specified for this operand is 575 bytes.
The function and specification method of this operand are the same as those of the PDSQLOPTLVL operand of the client environment definition. For details on the PDSQLOPTLVL operand, see the HiRDB Version 8 UAP Development Guide. If the HiRDB version number of the foreign server is different, see the manual for the correct version.
52) PDADDITIONALOPTLVL SQL-extension-optimization-option-for-foreign-HiRDB[,SQL-extension-optimization-option-for-foreign-HiRDB]...
[Figure]<identifier or unsigned integer>
Specifies the SQL extension optimization option for a foreign HiRDB. For details on SQL extension optimization, see the HiRDB Version 8 UAP Development Guide. If the HiRDB version number of the foreign server is different, see the manual for the correct version.
If this operand is omitted, the SQL extension optimization option that was set by the foreign HiRDB is applied. Specify this operand when the SQL extension optimization option of the foreign HiRDB is not to be used.
Operand rule
The maximum length of the character string that can be specified for this operand is 575 bytes.
The function and specification method of this operand are the same as those of the PDADDITIONALOPTLVL operand of the client environment definition. For details on the PDADDITIONALOPTLVL operand, see the HiRDB Version 8 UAP Development Guide. If the HiRDB version number of the foreign server is different, see the manual for the correct version.
53) PDAGGR number-of-groups-generated-for-foreign-HiRDB-grouping
32-bit mode: [Figure]<unsigned integer> ((0-30000000)) <<1024>>
64-bit mode: [Figure]<unsigned integer> ((0-2147483647)) <<1024>>
Specifies the maximum number of groups to be generated in each server to determine the amount of memory to be used for a GROUP BY process of a foreign HiRDB. This operand becomes valid when rapid grouping processing, which is an SQL optimization option, is to be executed in the foreign HiRDB.
The function and specification method of this operand are the same as those of the PDAGGR operand of the client environment definition. For details on the PDAGGR operand, see the HiRDB Version 8 UAP Development Guide. If the HiRDB version number of the foreign server is different, see the manual for the correct version.
54) PDHASHTBLSIZE hash-table-size-for-hash-join-subquery-hash-execution-by-foreign-HiRDB
32-bit mode: [Figure]<unsigned integer> ((128-524288)) (KB)
64-bit mode: [Figure]<unsigned integer> ((128-2097152)) (KB)
Specifies a hash table size (units: KB) when hash join, subquery hash execution, which is an SQL optimization option, is to be executed in a foreign HiRDB. If this operand is omitted, the value of the pd_hash_table_size operand of the foreign HiRDB is assumed.
The function and specification method of this operand are the same as those of the PDHASHTBLSIZE operand of the client environment definition. For details on the PDHASHTBLSIZE operand, see the HiRDB Version 8 UAP Development Guide. If the HiRDB version number of the foreign server is different, see the manual for the correct version.