Slow Query when perform INNER JOIN Between a very large partioned table and a non partitioned table

SQLServerCentral » Latest topics

Slow Query when perform INNER JOIN Between a very large partioned table and a non partitioned table

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)
Partit

more info...