Skip to main content

12 Posts on 12c: CTAS with Statistics

When executing a CREATE TABLE AS SELECT statement, new statistics are generated for this new database object. Unlike other features in this series, this is default behavior: BIG WIN.

Create the table.
Look, we have some statistics!
and column statistics!
and histograms!

It's just that simple. 

Comments