Re: Faster index creation

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 14 May 2008 20:46:07 GMT
Message-ID: <482b4f8f$0$30640$834e42db@reader.greatnowhere.com>


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: http://tinyurl.com/5hc3l

-- 
http://mgogala.freehostia.com
Received on Wed May 14 2008 - 15:46:07 CDT

Original text of this message