SQL402C - Temporary table created for hash join results

SQL402C
Message Text: Temporary table created for hash join results
Cause Text: The results of the hash join were written to a temporary table so that query processing could be completed. The temporary table was required because the query contained one or more of the following:
  • GROUP BY or summary functions
  • ORDER BY
  • DISTINCT
  • Expression containing columns from more than one table
  • Complex row selection involving columns from more than one table
Recovery Text: Refer to Data access on DB2 UDB for iSeries: data access paths and methods for more information about the hashing algorithm for join processing.
Parent topic: PRTSQLINF message reference