Stats on temp tables after implementing PSCBO_STATS
PSCBO_STATS will delete stats on temporary tables so dynamic sampling is triggered. I understand that due to the volatile nature of the data, not having stats on them is better than wrong stats. But what if I guarantee that right before running a big SQL that references a temp table, the table's stats are always gathered? Shouldn't accurate stats on the table, even if they are accurate only at that moment, be better for CBO than no stats so dynamic sampling takes over? Are the stats on temp tables deleted only because in practice it's difficult to have that guarantee,