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 -> Many indexes on a large table

Many indexes on a large table

From: Walter Campino <Walter_no_spam_Campino_at_iona.com>
Date: Thu, 30 May 2002 01:15:39 GMT
Message-ID: <%2fJ8.4717$1y3.232720513@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:15:39 CDT

Original text of this message

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