1.1.1

Creating Partitioned Tables
You create a partitioned table on a set of servers identified by named server groups (or on the default server
group if you do not specify a named server group). Clauses in the CREATE TABLE statement determine how
table data is partitioned, colocated, and replicated across the server group.
This topic focuses on the partitioning_clause in CREATE TABLE. The CREATE TABLE reference
page describes all of the options in more detail.
The partitioning_clause controls the location and distribution of data in server groups. Using server
groups and colocation is important for optimizing queries, and it is essential for cross-table joins. This version
of SQLFire does not support cross-table joins for non-colocated data, so you must choose the partitioning clause
carefully to enable the joins required by your application.
The partitioning clause can specify column partitioning, range partitioning, list partitioning, or expression
partitioning:
{
{
PARTITION BY { PRIMARY KEY | COLUMN ( column-name [ , column-name ]* )
}
|
vFabric SQLFire User's Guide64
Managing Your Data in vFabric SQLFire