> ## Documentation Index
> Fetch the complete documentation index at: https://clickhouse.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# cross_join_* session settings

> ClickHouse session settings in the cross_join_* generated group.

These settings are available in [system.settings](https://clickhouse.com/docs/reference/system-tables/settings.md) and are autogenerated from [source](https://github.com/ClickHouse/ClickHouse/blob/master/src/Core/Settings.cpp).

## cross\_join\_min\_bytes\_to\_compress

Type

UInt64

Default

1073741824

Minimal size of block to compress in CROSS JOIN, and in the [block nested loop join](https://clickhouse.com/docs/reference/statements/select/join.md#join-with-an-arbitrary-on-condition), which materializes its right side the same way. Zero value means - disable this threshold. This block is compressed when any of the two thresholds (by rows or by bytes) are reached.

## cross\_join\_min\_rows\_to\_compress

Type

UInt64

Default

10000000

Minimal count of rows to compress block in CROSS JOIN, and in the [block nested loop join](https://clickhouse.com/docs/reference/statements/select/join.md#join-with-an-arbitrary-on-condition), which materializes its right side the same way. Zero value means - disable this threshold. This block is compressed when any of the two thresholds (by rows or by bytes) are reached.
