Archives of the TeradataForum

Message Posted: Wed, 26 Apr 2006 @ 18:01:35 GMT

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

Naveen,

Just converting Primary Keys of OLTP system to Primary Index (Unique or Non Unique ) in Teradata is not a good approach. Primary Index is more of a physical design considerations. You might need to analyze your reports and frequently joined tables( and their data demographics) to decide an appropriate primary index for each table.

Regards,

Sandipan

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