Will lot of duplicate values in the joining columns skip the Index in teradata

Database

Will lot of duplicate values in the joining columns skip the Index in teradata

I was having a SQL running fine, that uses the Index on a date column. Now in these days it skips the Index in the explain plan and causing product join.

 

I could see lot of duplicate values in the Joining column. Is it a reason it cause product join.

 

Statistics are recently collected on both the tables.

  • product join
Tags (1)
1 REPLY
Enthusiast

Re: Will lot of duplicate values in the joining columns skip the Index in teradata

Yes that is the case. If possible, try using a PPI on date column along with PI of some uniformly distrubited column.