¶
10.5. Partition Functions
Given a key and a set of values, the partition function can determine which cluster nodes hold the value.
partition_list ( in table_name varchar,
in key_name varchar,
in list any,
in is_update int)
The table name is a case sensitive full name of a table as it appears in SYS_KEYS. The key_name is the case sensitive name of the index. The values are key part values in the index order. The is_update, if non-zero, specifies that if the value is stored in multiple places, all are to be returned, otherwise just one is picked at random, preferring the local if there is a local copy of the partition.
The value is a list of node numbers, corresponding to the Host<n> entries in the cluster.ini file.
Example:
select partition_list ('DB.DBA.CT', 'CT', vector (2), 1);