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.
Yes that is the case. If possible, try using a PPI on date column along with PI of some uniformly distrubited column.