Re: best way to invoke parallel in DW loads?

From: Greg Rahn <>
Date: Mon, 14 Sep 2009 15:30:30 -0700
Message-ID: <>

On Mon, Sep 14, 2009 at 10:14 AM, Kellyn Pedersen <> wrote:
> As I'm also currently working in a new environment with tons of parallel processes without  up to date statitistics-  STATS are ESSENTIAL to efficient parallel process execution!  I've been testing on a proof of concept that is showing up to 73% improvement in parallel processing performance just by having up to date statistics on partitions involved in any process.  Mind you that these schemas are 2-6TB each, but the performance improvement percentage could be similar and worth the time to prove.

Ah ha! Someone else that realizes that the right execution plan has more performance impact that any init.ora settings and the that cornerstone of optimal execution plans is representative stats. Please, go shout this from a mountain!!!

Greg Rahn
Received on Mon Sep 14 2009 - 17:30:30 CDT

Original text of this message