Az/OS system has some storage constraints. The results of-DIS STATS(INDEXMEMORYUSAGE) shows that a huge amount of storage is used for the fast index traversal processes.
What can be done to avoid this storage usage?
A . Reorganize the listed indexes
B . Set subsystem parameter INDEX_CLEANUP_THREADS to 0
C . Set subsystem parameter INDEX_MEMORY_CONTROL to DISABLE
D . Issue SQL statement ALTER INDEX ixname REGENERATE USING APPLICATION COMPATIBILITY V12R1M500 for the listed indexes
Answer: C
Latest C2090-318 Dumps Valid Version with 60 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund