Hi, We are using version 11 .2.0.4 of oracle exadata. We have some dynamic script as part of which few of the stage tables which will hold ~100's of millions of rows and primary key needs to be created to do the partition exchange with main partition table(which holds local primary key/indexes). So to handle this , we are planning to create indexes first in parallel on the stage table. And we want to add primary key constraints to it after the indexes created to make things faster. So want to understand, if we don't pass the index name explicitly, then does below syntax will automatically use the already created index(on same set of columns) to add the primary key constraints? or it won't and Oracle will again scan all those data to create the PK and so will take the same amount of time which it would have taken for creating index in serial fashion?
alter table tab1 add constraint tab1_k primary key(id) using index; -- Without explicitly mentioning what index to use.