COLLECT STATS

Database
Enthusiast

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 );

2 REPLIES
Enthusiast

Re: COLLECT STATS

Hi,

Can anyone advice?

Regards

John

Junior Contributor

Re: COLLECT STATS

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.