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?