Create index with parallel or nologging option

Maximize the creation of index speed with nologging or parallel option:

Disable the log generation during creation of index:

create index inv_idx1 on inv(inv_id, inv_id2)
nologging
tablespace inv_mgmt_index;

Increase the degree of parallelism for creating index on large table

create index inv_idx1 on inv(inv_id)
parallel 4
tablespace inv_mgmt_data;

Verify the index degree

select index_name,logging, degree from user_indexes;

Rebuild index with parallel and no logging mode:

alter index inv_idx1 rebuild parallel 4 nologging;

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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s