Chat now with support
Chat with Support

Spotlight on SAP ASE 2.12 - Getting Started Guide

Hash Loops

The number of times that a single partition of a hash join was larger than the available sort heap space. This could be an indicator of a poorly performing hash join. Try increasing the SHEAPTHRES for the instance or the SORTHEAP for the database or partition to alleviate this issue.

Note: In a multiple-partition database, information is presented for each active partition on the system. An All Nodes row keeps a running total for all partitions. In a single-partition database, only the All Nodes information is presented.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating