(16.0 only)
Temp
Data in Shared Temp
– When ON (the default), all temporary table data and eligible
scratch data writes to the shared temporary store if it is not
empty. (If the shared temporary store contains no read-write file,
data instead writes to IQ_SYSTEM_TEMP.) When OFF, all temporary
table data and scratch data writes to the local temporary
store.If you change the value of Temp Data in Shared
Temp, you must restart all servers that belong to
this logical server. After the restart, each server that is part of
the logical server begins putting temporary table data in the
appropriate store.
(16.0 only) DQP Enabled
– Specify DQP disabled, Enable
DQP with shared temp (the default), or Enable DQP over the network. You can reset this option dynamically. Distributed query
processing (DQP) over the network keeps data in memory in the
temporary cache instead of in the IQ_SHARED_TEMP dbspace. The
option that provides the best performance may vary by query, and
depends on the performance of the network relative to the I/O
system.