Re: Is it a good idea to have primary key on DW table
- From: Taral Desai <taral.desai@xxxxxxxxx>
- To: my.oralce@xxxxxxxxx
- Date: Wed, 4 Aug 2010 16:35:59 -0500
Also, to add
Constraints in DW is not just for integrity but also for performance. If you
have right constraints then it can improve performance.
Optimizer is smart enough to see that and will give you plan accordingly
On Tue, Aug 3, 2010 at 11:53 PM, Anupam Pandey <my.oralce@xxxxxxxxx> wrote:
> 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
>
>
--
Thanks & Regards,
Taral Desai
Other related posts:
