Archives of the TeradataForum

Message Posted: Fri, 15 Jun 2012 @ 10:21:45 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Friday, June 15, 2012 01:48 -->

Dear Nathan,

There are 2 options

1.) one is that you create Surrogate key for Fact table to get data distribution evenly and then all Foreign keys can be defined as Seconday indexes for better Query utilisation and Hope Collect Stats would be refreshed on big updates on required columns......

2.) Second option is that all 4 FK's can be made combined PI's But their is the possibliltiy that data is not properly distributed and if skewness factor is not much then you can go ahead with teh same...

Regards

	<Prev	Next>		<<First	<Prev	Next>	Last>>