CREATE GLOBAL HASH INDEX

Creates an index that contains unique values across all of the members that host a partitioned table's data.

Syntax

CREATE GLOBAL HASH INDEX index-name 
ON table-name ( 
column-name [ , column-name ] * )

Description

A global hash index in SQLFire 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. SQLFire 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).

Example

–- create a hash based globally unique index 

CREATE GLOBAL HASH INDEX fl_idx ON FLIGHTS (flight_id, segment_number)