Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Many indexes on a large table

Re: Many indexes on a large table

From: Karl Larson <karl.larson_at_cox.net>
Date: Thu, 30 May 2002 01:29:31 GMT
Message-ID: <%ffJ8.5857$ok.429750@news2.east.cox.net>


Set your sort_area_size for the process that creates the indexes very large. This has worked well for me in the past with large indexes.

"Walter Campino" <Walter_no_spam_Campino_at_iona.com> wrote in message news:%2fJ8.4717$1y3.232720513_at_newssvr16.news.prodigy.com...
> I have a table with:
>
> 1) Rows of about 300 bytes each
> 2) 200 million rows
> 3) 20 indexes
>
> This table is part of a product, so the design is not open to change (at
> least in the short run).
> At one stage in the batch-process of building this table, 20 indexes are
> created.
> This is done in a very simple way... by issuing 20 CREATE INDEX
> statements.
> Each takes a little under an hour to complete, with 15 hours to create all
> 20 indexes.
>
> Questions:
>
> 1) Can I somehow build these in parallel (this is a 12 CPU machine, and we
> can use them all)
> 2) Any other suggestions
>
> Thanks
>
> Walter [Please post replies to the newsgroup]
>
>
>
>
Received on Wed May 29 2002 - 20:29:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US