While Joining Two table On PRIMARY INDEX and Secondary INDEX

General
Enthusiast

While Joining Two table On PRIMARY INDEX and Secondary INDEX

Hi,

While we are joining two tables Table A and Table B, are joining on Column C . In Table A , column C is Primary Index and In table B it is a Secondary Index.

WIll it be the same senario if column C was not secondary Index for Table B. Just any other column...

Imean in a Join (Not Nested) DO secondary index have any extra miles to go than any other column?