Toad World® Forums

After Alteration with Drop/Create Unload/Load only Runstats on Tablespace is made, not on Index


#1

Hello,

when a colum is altered with with Drop/Create Unload/Load only Runstats on Tablespace is made, no Runstats on Index is made. Then Rebind is done.

Runstats-information on Index is also needed!

DROP TABLE “#DB2IDV1”.TBWH_ELB_DECK_HI;

CREATE TABLE “#DB2IDV1”.TBWH_ELB_DECK_HI (…

– Step 6. Runstats

RUNSTATS TABLESPACE DWH2079.SWH0739 TABLE ("#DB2IDV1".“TBWH_ELB_DECK_HI”);

– Step 7. Rebind

REBIND PACKAGE (COLDEFLT.MWHELB1.(2014-08-06-13.11.22.950308));

This should be generated:

RUNSTATS TABLESPACE DWH2079.SWH0739
TABLE (ALL) SAMPLE 25
INDEX (ALL)
SHRLEVEL CHANGE
REPORT NO
UPDATE ALL
HISTORY NONE;

RUNSTATS TABLESPACE DWH2079.SWH0739
TABLE (ALL) SAMPLE 25
INDEX (ALL)
SHRLEVEL CHANGE
REPORT NO
UPDATE ALL
HISTORY NONE;


#2

Thanks for the feedback. We have recreated this issue and have created TDB-1217 to track this.

Thanks

Jeff