View previous topic :: View next topic
|
Author |
Message |
nitinkumar.v
New User
Joined: 11 Oct 2007 Posts: 2 Location: india
|
|
|
|
RUNSTATS TABLESPACE DB2CERTDB.MYTBLSPC1
TABLE (MYTABLE1) COLUMN(ALL)
INDEX
REPORT YES
UPDATE ALL
HISTORY ALL
which of the following statements is true?
A. Cardinality statistics will only be collected on all columns of all indexes on table MYTABLE1.
B. Cardinality statistics will only be collected on the first column of each index on table MYTABLE1.
C. Cardinality statistics will only be collected on all columns of each index associated with table space MYTBLSPC1.
D. Cardinality statistics will only be collected on the first column of each index associated with table space MYTBLSPC1.
[/b] |
|
Back to top |
|
|
Ketan Varhade
Active User
Joined: 29 Jun 2009 Posts: 197 Location: Mumbai
|
|
|
|
A is the correct answer |
|
Back to top |
|
|
nitinkumar.v
New User
Joined: 11 Oct 2007 Posts: 2 Location: india
|
|
|
|
But what i came to know is that...
this will give the statistics of all the columns of the table MYTABLE1 plus the first column of the index...
according to which ans B is correct but partially ....
but surprisingly the given ans is D
|
|
Back to top |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008 Posts: 193 Location: chennai
|
|
|
|
Hi
If the question given in the forum is correct, then there is no correct answer. Because the utility will throw an error.
RUNSTATS TABLESPACE DB2CERTDB.MYTBLSPC1
The length of database name and tablespace name is greater than 8 character.
Raghu |
|
Back to top |
|
|
|