Is it a good idea to have primary key on DW table

From: Anupam Pandey <my.oralce@xxxxxxxxx>
To: oracle Freelists <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 4 Aug 2010 10:23:56 +0530

Hi Listers,
                I was trying to do a poc whether its good idea to have the
primary key constraint on FACT table in DW envioronment or not .

Here is what i found :-

1. Once I loaded the table for few days and started the primary key creation
process ,other select queries on that table was blocked.

      SID SQL_ID SQL_HASH_VALUE BLOCKING_INSTANCE BLOCKING_SESSION SQL_TEXT
1 322 5adg0zfm9zrat 2795494745     alter table FACT_TEST add constraint
pk_FACT_TEST primary key (<COLUMN_LIST>)   2 389 9n8jftdhvb5q0 1639290560 1
322 select date_key,count(*) from fact_test group by date_key

Follow-Ups:

Re: Is it a good idea to have primary key on DW table
From: Anupam Pandey

RE: Is it a good idea to have primary key on DW table
From: Powell, Mark

Re: Is it a good idea to have primary key on DW table
From: Tim Gorman

Re: Is it a good idea to have primary key on DW table
From: Taral Desai

Is it a good idea to have primary key on DW table

Other related posts: