| Index Creation with Parallel Option [message #350349] |
Wed, 24 September 2008 15:41  |
faiz_hyd
Messages: 294
Registered: February 2006
|
Senior Member |
|
|
Hi,
I have created indexes with parallel Degree 6 or 8 and they were
fast on 400 million rows table, (it took around 20-30 minutes )
But now there is a requirement to create a Unique deferred Constraint which will create a NON Unique index
I am using this
ALTER TABLE PAYMENTS ADD ( CONSTRAINT UNI_PYM_TRANSID_PYMT_SEQ UNIQUE (TRANS_ID, PYMT_SEQ) deferrable initially deferred) ;
This statement will take forever on a 400 mill rows table, since internally it's creating a index and here i cann't apply Parallel Degree for Index Creation,
Is there a way i can speed up the above constraint creation.
Thanks
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
