Re: Creating indexes on a large table
From: Roger Snowden <snowden_at_haven.ios.com>
Date: 1995/09/18
Message-ID: <43k8fe$ehf_at_news.ios.com>#1/1
: > Hi netters,
: > 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.
Date: 1995/09/18
Message-ID: <43k8fe$ehf_at_news.ios.com>#1/1
: Dipankar (dasdipa_at_zeus.franklin.edu) wrote:
: > Hi netters,
: > 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.
You may be able to improve performance by increasing the SORT_AREA_SIZE parameter in your init.ora startup file for your instance. It defaults to 64K, I believe and may be increased for just such purposes. You may want to increase it temporarily and put it back after the index is created.
Roger Received on Mon Sep 18 1995 - 00:00:00 CEST