Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: How to disable hast join - performance problem?

    Hi,

    I have performance problem with joining tables. With Visual Access Plan I have found out that tables are joined togeter with HASH JOIN type. I would like that DB2 uses only nested loop joins or merge joins.

    Is it posible to set some DB2 setting to disable hash join?

    My system: DB2 UDB 8.1 fp4 on Windows XP.

    Thanks,
    Grofaty
    Last edited by grofaty; 12-12-03 at 07:16.

  2. #2
    Join Date
    Nov 2003
    Location
    Netherlands
    Posts
    96

    Re: hast join - performance problem

    Originally posted by grofaty
    Hi,

    I have performance problem with joining tables. I have found out that tables are joined togeter with HASH JOIN type. I would like that database uses only nested loop joins or merge joins. Is it posible to set some DB2 setting to disable hash join?

    Thanks,
    Grofaty
    Hi,

    You can disable hash joins with db2set DB2_HASH_JOIN=NO

    regards, Gert

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    Hi GertK,

    This command works fine. Thanks.

    Grofaty

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •