Re: Faster index creation

From: Mladen Gogala <>
Date: 14 May 2008 20:46:07 GMT
Message-ID: <482b4f8f$0$30640$>

On Wed, 14 May 2008 10:33:24 -0700, Mark D Powell wrote:

> I would set work area management policy to manual, set the largest
> practical sort_area_size possible and just run one index build at a
> time.

This no longer applies to 10.2 and later. There is a new sort algorithm in 10.2, specifically rewritten to make use of larger memories, available through PGA_AGGREGATE_TARGET. There is a paper about this here:

Received on Wed May 14 2008 - 15:46:07 CDT

Original text of this message