Index creation - performance problem

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 Received on Wed Mar 08 2000 - 00:00:00 CST