IBM

C2090-320 · Question #40

Which catalog table would you query in order to determine the relevant statistics for an index?

The correct answer is D. SYSIBM.SYSINDEXSTATS. See the full explanation below for the reasoning.

Question

Which catalog table would you query in order to determine the relevant statistics for an index?

Options

ASYSIBM.SYSKEYS
BSYSIBM.SYSFIELDS
CSYSIBM.SYSCOLUMNS
DSYSIBM.SYSINDEXSTATS

How the community answered

(37 responses)

A
8% (3)
B
3% (1)
C
5% (2)
D
84% (31)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full C2090-320 Practice