Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011
    Posts
    7

    Unanswered: Sort overflow/Hash join overflow high

    Dear, experts
    I am having a high overflow rate for sort and hash join. Heap memory sets as following :
    Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = 51200
    Sort list heap (4KB) (SORTHEAP) = 5120
    I have increased them double but no changes on the overflow rate...Any idea where to look and solve the issue?
    Thank you.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Quote Originally Posted by Beemer View Post
    Any idea where to look and solve the issue?
    Thank you.
    a) Query Tuning
    b) Indexing
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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