Im running Oracle 10g on Solaris 10 and I was wondering if there is a way to create an index faster than it is right now....
Im running this script but its taking too long:
CREATE UNIQUE INDEX IX_AK1_Dp_SKey ON Dp_SKey
(DpSC_Id ASC, DpSA_Id ASC, DpSD_Id ASC, DpSK_Index ASC, DpSK_Type ASC, DpSK_Vers
Note that Im using the PARALLEL option.. maybe this will make it go faster or it will make no difference?
alter session force parallel ddl;
The table to be indexed - Dp_SKey - have 686176534 rows...
Its taking 90 min at the moment