PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center