September 2017

Gathering Stats When Loading Data

Introduced in 12c, in some situations we can gather stats online when the data is loaded without taking any extra time: 1) When doing a direct path load (the APPEND or PARALLEL hint uses direct path loads) 2) The table is empty before the load. If both those are true, use the hint GATHER_OPTIMIZER_STATISTICS and […]

Read more →