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