Urgent : join between primary index and secondary index

Database
Enthusiast

Urgent : join between primary index and secondary index

What are the pros and cons if we join between primary index and secondary index

Example:-

Table_1
Primary index( t1,t2)
Secondary index ( t3,t4,t5,t6)

Table_2
Primary index(t1,t2)

Join
Table_1.t4 = Table_2.t1
And
Table_1.t5= Table_2.t2

Thanks in advance,
Mahesh
2 REPLIES
Enthusiast

Re: Urgent : join between primary index and secondary index

What are the pros and cons if we join between primary index and secondary index

Example:-

Table_1
Primary index( t1,t2)
Secondary index ( t3,t4,t5,t6)

Table_2
Primary index(t1,t2)

Join
Table_1.t4 = Table_2.t1
And
Table_1.t5= Table_2.t2

Is 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 ?
Enthusiast

Re: Urgent : join between primary index and secondary index

.