IBM
C2090-619 · Question #96
Given an OLTP environment with a very large table, which configuration parameter can be set to allocate more memory for sorting when building an index on the large table?
The correct answer is D. DS_NONPDQ_QUERY_MEM. See the full explanation below for the reasoning.
Question
Given an OLTP environment with a very large table, which configuration parameter can be set to allocate more memory for sorting when building an index on the large table?
Options
- ADBUPSPACE
- BDS_POOLSIZE
- CVP_MEMORY_CACHE_KB
- DDS_NONPDQ_QUERY_MEM
How the community answered
(23 responses)- A4% (1)
- B13% (3)
- C4% (1)
- D78% (18)
Community Discussion
No community discussion yet for this question.