Re: Creating indexes on a large table
From: Tony Damon <ardamon_at_srv.PacBell.COM>
Date: 1995/09/14
Message-ID: <43a4g6$6lu_at_gw.PacBell.COM>#1/1
Date: 1995/09/14
Message-ID: <43a4g6$6lu_at_gw.PacBell.COM>#1/1
In article 8aj_at_newsbf02.news.aol.com, biggsbm_at_aol.com (BiggsBM) writes:
>>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 your data can be sorted before the sql*loader setp then try using the NOSORT option on the CREATE INDEX step.
Tony Damon
Pacific Bell
ardamon_at_pacbell.com
Received on Thu Sep 14 1995 - 00:00:00 CEST