Archives of the TeradataForum

Message Posted: Wed, 24 Jun 2009 @ 13:26:35 GMT

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

Hi --

I am looking for some feedback on indexing for intersection tables. Something like a, Student_Enrollment table, that is an intersection between a Student (PI - StudentID) table and a Course (PI - ClassID) table. Would I be better off with a combined Unique index of (StudentID, ClassID) OR a Non Unique PI of Student ID OR Course ID alone (to facilitate collocation/same amp join with either of these two tables) for the Student_Enrollment table. What are the factors to consider?

Thanks.

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