Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Catalogs/ SPM/ GS_SPM_ID_HASH_JOIN
Updated on 2025-08-19 GMT+08:00
View PDF

GS_SPM_ID_HASH_JOIN

GS_SPM_ID_HASH_JOIN is a system catalog in the SPM feature. Currently, this feature is not supported in the distributed system. The system catalog stores the relationship between unique_sql_id and sql_hash. Users with sysadmin permissions can read the system catalog, but only the initial user can write data to the system catalog.

Table 1 GS_SPM_ID_HASH_JOIN columns

Name

Type

Description

unique_sql_id

bigint

Unique ID of an SQL statement in the database.

sql_hash

bigint

Unique ID of the SQL statement in the SPM.
Parent topic: SPM