Skip to content
September 3, 2015 / doganay

HOW TO CREATE A PRIMARY KEY PARALEL

1. Create the primary key constraint (disabled)

alter table t1 add (
constraint t1_pk
primary key (col1))
disable primary key;

2. Create a unique index with the same name & columns as the primary key

create unique index t1_pk on t1(col1)
parallel (degree 5)
unrecoverable;

3. Enable the primary key

alter table t1 enable primary key;
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: