Re: Creating indexes on a large table

dasdipa_at_zeus.franklin.edu writes in article <1995Sep8.025004.19522_at_zeus.franklin.edu>:
>
> 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.
>
> Any help / suggestions to create indexes in an efficient way would be
> greatly appreciated.
>
Check the sort_area_size in init.ora. The higher you set it, the more sort-space (for index build, but also for other sort-operations) you will get.

Willy Klotz
>

Willys Mail     FidoNet              2:2474/117  2:2474/118    
      willyk_at_kbigate.stgt.sub.org      VFC        ISDN/X.75