Archives of the TeradataForum
Message Posted: Wed, 24 Jun 2009 @ 13:26:35 GMT
| Subj: || || Indexing Intersection (association) tables |
| From: || || Goli, Srikanth |
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?