1.1.1

Note: The server group names that you specify are converted to all-uppercase
characters, even if you specify a quoted identifier.
Note: You can configure both partitioned tables and replicated tables to use a
gateway sender. However, you must create replicated tables in the same server
groups as the gateway sender(s) that you specify in the CREATE TABLE
statement.
Example
Create and start a gateway sender with persistence:
CREATE GATEWAYSENDER cluster-1-sender
(
REMOTEDSID 2
ENABLEPERSISTENCE true
DISKSTORENAME cluster-1-wan-store
)
SERVER GROUPS (primary_sender_group);
Information for the gateway sender is added to the GATEWAYSENDERS.
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);
CREATE INDEX
Creates an index on one or more columns of a table.
Syntax
CREATE [ UNIQUE ] INDEX index_name
ON table-name (
column-name [ ASC | DESC ]
vFabric SQLFire User's Guide486
vFabric SQLFire Reference