PrepAway - Latest Free Exam Questions & Answers

which two of the following columns would NOT be needed?

In determining whether a REORG on an index space would improve performance, which two of
the following columns would NOT be needed? (Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
Column CLUSTERING in SYSIBM.SYSINDEXES

B.
Column LEAFDIST in SYSIBM.SYSINDEXPART

C.
Column CLUSTERRATIOF in SYSIBM.SYSINDEXES

D.
Column LASTUSED in SYSIBM.SYSINDEXSPACESTATS

E.
Columns LEAFNEAR and LEAFFAR in SYSIBM.SYSINDEXPART

Explanation:


Leave a Reply