Re: Many indexes on a large table

Good suggestion.
Depending on your disk layout creating in parallel may also help.

Also try adding a 'nologging' (8i) or 'unrecoverable' (7)parameter onto the create statement.
It will speed it up. But read up on the 'side effects' of doing so.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

Author of: 'So You Want to be an Oracle DBA?'

"Karl Larson" <karl.larson_at_cox.net> wrote in message news:%ffJ8.5857$ok.429750_at_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 Thu May 30 2002 - 05:56:34 CDT