An expression-based index named EMPJND1 and a statistical view named EMP_IND1_V have
been created for a table named EMPLOYEE.
If the following command is used to set up a statistics profile on the statistical view EMP_IND1_V:
RUNSTATS ON VIEW emp_ind1_v WITH DISTRIBUTION DEFAULT UM_FREQVALUES 50 SET
PROFILE ONLY
Which command will create a statistics profile on the EMPLOYEE table?

A.
RUNSTATS ON TABLE employee USE PROFILE
B.
RUNSTATS ON TABLE employee USE SAMPLED INDEX emp_ind1
C.
RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED DETAILED
INDEXES ALL
D.
RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED INDEX emp_ind1
GENERATE PROFILE
https://www.ibm.com/support/knowledgecenter/fi/SSEPGG_10.5.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0001980.html
0
0