# setMemLimitOfTempResult {#setmemlimitoftempresult}

**Parent topic:**[Functions](../../Functions/category.md)

## Syntax {#syntax}

`setMemLimitOfTempResult(X)`

## Arguments {#arguments}

**X** is a positive number that is no greater than *maxMemSize*.

## Details {#details}

Modifies the upper limit of memory usage \(in GB\) for each temporary result generated during a table join operation. It can only be executed by an administrator on a data node or compute node.

**Note:**

The modified configuration will expire after the cluster is rebooted. To make it permanent, please change the configuration parameter *memLimitOfTempResult*.

