Re: Creating indexes on a large table

From: BiggsBM <biggsbm_at_aol.com>
Date: 1995/09/13
Message-ID: <435mic$8aj_at_newsbf02.news.aol.com>#1/1

>I am trying to create an index on 2 columns of a large table
>( 8 million rows) after loading the data through SQL*Loader.
>This process was taking days together. Running ORACLE 7.1.4
>on NT server. Database is of 9.5 Gig out of 10 Gig available
>on the machine. SGA is of 24 MB out of 100 MB total memory.

If you are using a machine with multiple processors, and your tablespaces are spread out across multiple drives, you could try using the parallel index creation option to speed things up. There is a good discussion of parallel index creation in one of the Oracle manuals, although I can't remember which one right now.

Good luck,
Brian
Cincom Systems, Inc.
bbiggs_at_cincom.com Received on Wed Sep 13 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Simon Thompson: "Re: Export table to comma delimited file?"
Previous message: Graham Sewell: "Re: Oracle V7.1 show-stopping performance problem"
In reply to: Dipankar: "Creating indexes on a large table"
Next in thread: Tony Damon: "Re: Creating indexes on a large table"
Reply: Tony Damon: "Re: Creating indexes on a large table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message