Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: statistics
EXPORT not GATHER with DBMS_STATS
Just a short post today on something that came in as a question for the upcoming Office Hours session which I thought could be covered quickly in a blog post without needing a lot of additional discussion for which Office Hours is more suited…
12c Statistics on load–special cases
One of the cool features in 12c is the automatic collection of optimizer statistics when a table is either created or loaded via direct path from empty. This makes a lot of sense because it saves us from what used to be the mandatory…
