Monthly Archive: June 2015

12c New Feature – Online Statistics Gathering for Bulk Loads

How many times have we had to execute a CREATE TABLE AS SELECT or INSERT INTO…SELECT that involved a large amount of data then wondered why queries against this table are slow? Did we forget to gather statistics after the fact perhaps? Well in Oracle Database 12c there is a new feature that will gather online statistics for you when performing bulk loads when using either one of two bulk loading methods: 1) CREATE TABLE AS SELECT 2) INSERT INTO … SELECT into an empty table using a direct path insert   Example – Default Behavior (CREATE TABLE AS SELECT)…
Read more