Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Slow Query when perform INNER JOIN Between a very large partioned table and a non partitioned table RE: Slow Query when perform INNER JOIN Between a very large partioned table and a non partitioned table

  • February 10, 2018 at 1:23 am

    #1979340

    karim.diouf - Friday, February 9, 2018 3:25 PM

    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

    Too little information, please post the actual execution plan, the query and the full DDL for the tables in question.
    😎