DS_NONPDQ_QUERY_MEM and hash table

Posted in 2011

CHUAN LU — Thu, 01 Dec 2011 05:41:22 — source: IIUG Forums & Mailing Lists

Hi, In the hash join, Do the hash table being stored in DS_NONPDQ_QUERY_MEM or other area in the virtual segment? if it was stored in the DS_NONPDQ_QUERY_MEM , the size of the hash table is large than the DS_NONPDQ_QUERY_MEM ? what the additional data should be stored? Is it in the DBSPACETEMP? thanks.