IBM

C2090-320 · Question #31

In order to evaluate the real-time relative disorganization of an index, which catalog table would you query?

The correct answer is D. SYSIBM.SYSINDEXSPACESTATS. storytables.html

Reports and Monitoring

Question

In order to evaluate the real-time relative disorganization of an index, which catalog table would you query?

Options

ASYSIBM.SYSINDEXES
BSYSIBM.SYSINDEXPART
CSYSIBM.SYSINDEXSTATS
DSYSIBM.SYSINDEXSPACESTATS

How the community answered

(42 responses)

A
10% (4)
B
2% (1)
C
7% (3)
D
81% (34)

Explanation

storytables.html

Topics

#index disorganization#catalog table#SYSINDEXSPACESTATS#real-time statistics

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full C2090-320 Practice