Re: Index creation - performance problem

Also, consider:

     create unique index INDEX_NAME on TABLE_NAME (FIELD_NAME) -> parallel (degree 4)

     tablespace MY_INDEX_TABLESPACE_NAME
     storage (initial MY_INITIAL_EXTENT_SIZE, next ...)

Notice the parallel clause.
I use degree 4 which gives me about 1/2 the run time versus without the parallel clause.

<rspeaker_at_my-deja.com> wrote in message news:8a662q$ufa$1_at_nnrp1.deja.com...
> where is the index being stored? Did you specify a storage creation
> clause with the index? If not it is most likely either being stored
> with the table, or in your default tablespace. Also, if you did not
> specify a storage clause, you are creating the index with the default
> storage parameters of the tablespace, which may be very small and
> inefficient extent settings. I had a developer one time trying to
> create an index on a 1 GB table using default storage parameters (8k/4k)
> and it took HOURS.
>
> You may also want to consider using the UNRECOVERABLE option for the
> index to avoid generating significant amounts of redo.
>
> HTH,
> Roy
>
>
> In article <38C6758D.339F0603_at_royalpbk.com>,
> Adam Roze <arz_at_royalpbk.com> wrote:
> > Hi,
> >
> > I am trying to create unique index on a big table.
> > Table is placed on separated datafile/tablespace/disk . Monitoring
 disk
> > activity shows that oracle reads and writes about the same
> > amount of data ~2.5 MB/s.
> >
> > I understand that oracle has to read the table to create index but why
> > does it write to it ??? Is it possible to avoid ??
> >
> > As the table is big ~6GB it takes an hour to create the index and I
> > hope that elimination of writes would make it faster.
> >
> > Oracle is 7.3.4.5 on Digital Unix 4.0E
> >
> > Any help would be greatly appreciated.
> >
> > Adam
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Mar 08 2000 - 00:00:00 CST