0 - 2 of 2 tags for all-row scan

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.