|Statements / CREATE Statements|
Creates an index that contains unique values across all of the members that host a partitioned table's data.
CREATE GLOBAL HASH INDEX index-name ON table-name ( column-name [ , column-name ] * )
A global hash index in GemFire XD is like a partitioned table with hash partitioning on the index columns. Only equality based join operations involving index columns use the hash index for pruning the set of members required to service the query. GemFire XD creates global hash index implicitly for foreign key and unique key constraints when the partitioning column differs from the primary key of a table.
The index data itself can reside in multiple members, including members other than those that host the table's data but restricted to data stores (i.e. members booted with 'host-data' as true).
–- create a hash based globally unique index CREATE GLOBAL HASH INDEX fl_idx ON FLIGHTS (flight_id, segment_number);