InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 16:27:18 GMT20http://www.teradata.com/teradataforum/Topic12475-9-1.aspx.Wed, 20 Aug 2008 13:04:34 GMTSireehttp://www.teradata.com/teradataforum/Topic12475-9-1.aspxWhat are the pros and cons if we join between primary index and secondary index Example:-Table_1Primary index( t1,t2)Secondary index ( t3,t4,t5,t6)Table_2Primary index(t1,t2)JoinTable_1.t4 = Table_2.t1AndTable_1.t5= Table_2.t2Is it good recommending to created secondary index , If join column is not part of Primary Index, Is there any issues ?What are the recommendations for joining primary index column with non primacy index column ? Thu, 07 Aug 2008 17:49:49 GMTSireehttp://www.teradata.com/teradataforum/Topic12475-9-1.aspxWhat are the pros and cons if we join between primary index and secondary index Example:-Table_1Primary index( t1,t2)Secondary index ( t3,t4,t5,t6)Table_2Primary index(t1,t2)JoinTable_1.t4 = Table_2.t1AndTable_1.t5= Table_2.t2Thanks in advance,MaheshThu, 07 Aug 2008 14:12:24 GMTSiree