Re: Building indexes in parallel

From: Ping <pgzhang_at_cris.com>
Date: 1996/09/29
Message-ID: <52ko0t$aru_at_herald.concentric.net>#1/1

Anyway, here is the way to create your PK index in parallel :

Step 1. Disable your PK when you create it , ie.

                 alter table tab_name
                 add constraint cons_name primary key
                 ( column_list )
                 disable;

Step 2. Create a uniq index on the column_list using parallel option
                 create uniq index pk_tab_name on tab_name
                 (column_list ) 
                 parallel (degree 8 );

Step 3. Enable the pk
                 alter table tab_name enable primary key;


                       
                          


++++++++++++++++++++++++++++++++++++++++++++++++++++++

Ping Zhang
DBA
Transquest, Inc.
770-989-0261(H) 404-773-9088 (O)
pgzhang_at_cris.com or ping.zhang_at_mailport.delta-air.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++
Received on Sun Sep 29 1996 - 00:00:00 CEST