Replicated Tables and Partitioned Tables

Tables in SQLFire can be partitioned or replicated. A replicated table keeps a copy of its entire data set locally on every SQLFire server in its server group. A partitioned table manages large volumes of data by partitioning it into manageable chunks and distributing those chunks across all members in the table's server group.

By default, all tables are replicated unless you specify partitioning in the CREATE TABLE statement. (You can change the default behavior to create partitioned tables using the table-default-partitioned boot property). The schema information for all SQLFire objects is visible at all times to all peer members of the distributed system including peer clients, but excluding standalone locators.

Partitioning Tables and Replicating Tables provide more information.