Hello, I added distribution stats on a set of indexes using this
syntax:



RUNSTATS TABLESPACE DBTMR130.TSMR007

TABLE (MRT13.VMR007AP_CA_PR_RNG)

SHRLEVEL REFERENCE

INDEX ALL KEYCARD FREQVAL NUMCOLS 10 COUNT 10





The intent was to do this in order to make DB2 choose a particular INDEX
for a query, which worked as planned.



When I try to back out the change and have DB2 choose the old INDEX I
have trouble.



Does anybody know of a procedure for removing such distribution stats?
The only way I found to do it was by dropping and redefining the Table.




I tried deleting rows from SYSCOLDIST as well as deleting all rows from
table first and then redoing RUNSTATS ( without distribution ) - Only
the table drop would work.





Thanks.




DB2 & UDB email list listserv db2-l LazyDBA home page