I have a very large - partitioned - table with about 50 millions records. Partition column is PeriodDate (format: YYYYMM)
I need to perform an Inner Join between that partitioned table and a - non partitioned table - (about 3 millions rows)
Partitioned Data is not sorted (Data could be sorted, if correct index is created, but within every single partition of the partitioned table. Not globally!)
It seems that, in that case, the only join type available is the HASH JOIN.....
My problem is that the query is very slow when using the HASH JOIN.
Do you have a better option? Please help