Hi I am gettnig all-row scan even after using a secondary Index at the driving table. I am not sure if my approach is right , so please help me out here.

Hi all,

Can any one of you guide me that in Teradata EXPLAIN plan what will result  if it might indicate a missing join condition?

A. all-AMP join, B. all-row scan or  C. missing join condition.

Regards,

Aamir