All Forums Database
johnsunnydew 43 posts Joined 09/14
01 Jan 2015
COLLECT STATS

Hi There,
Can u tell from the below Collect Stats , if both are same? If both are same which would be faster and which is advisable to be used
  COLLECT STATISTICS ON SAMPLE INDEX FACTOR_ID;

  COLLECT STATISTICS ON SAMPLE INDEX IDX_SAMPLE;

 
My table looks like below.

CREATE SET TABLE SAMPLE ,NO FALLBACK ,

     NO BEFORE JOURNAL,

     NO AFTER JOURNAL,

     CHECKSUM = DEFAULT,

     DEFAULT MERGEBLOCKRATIO

     (

      FACTOR_ID DECIMAL(27,0) NOT NULL,

      FACTOR_TYPE VARCHAR(32) CHARACTER SET LATIN CASESPECIFIC NOT NULL

)

      PRIMARY INDEX IDX_SAMPLE(FACTOR_ID );

johnsunnydew 43 posts Joined 09/14
01 Jan 2015

Hi,
Can anyone advice?
 
Regards
John

dnoeth 4628 posts Joined 11/04
01 Jan 2015

Hi John,
it's not the same as the first COLLECT will fail without brackets around FACTOR_ID :-)
 
Otherwise both are processed exactly the same, simply check Explain.

Dieter

You must sign in to leave a comment.