Hi Folks,
1) Why do we have to commit so that statistics are taken into account :
Insert into DGTT
call ADMIN_CMD ('runstats ...')
<<- If we don't commit here, explain plans show that stats are not taken
into account for the following select.
select * from DGTT where ....
Is that correct ? If so, this always implies to have DGTT with on DELETE
PRESERVE ROWS.
2) Why can't we issue an ALTER TABLE ... VOLATILE on such tables ?
We used to do it for Not Logged Initially tables, and switching to DGTT
seems to imply "you'd better run stats".
Thanks for your help,
JM