Product Documentation

FairCom Database Engine Partitioned Files

Previous Topic

Next Topic

Partitioned Files Available via FairCom DB SQL

Partitioned files are available directly through FairCom DB SQL. As partitioned files rely on a key value to partition the data, the option is part of the CREATE INDEX statement. By including the STORAGE_ATTRIBUTES clause with the PARTITION option, the file will be rebuilt to enable partitioned support. All other operations on the file will continue as usual.

Note: Partitioned file support requires a custom build of FairCom DB SQL with the partition rule compiled from the ctpart.c module.

FairCom DB SQL CREATE INDEX Syntax

CREATE [ UNIQUE ] INDEX index_name

ON table_name

( {column_name [ASC | DESC]} [, ...])

[ STORAGE_ATTRIBUTES 'attributes' ];

New Argument:

STORAGE_ATTRIBUTES 'attributes'

A quoted string that specifies index attributes that are specific to FairCom DB SQL indexes. FairCom DB SQL interprets the following attribute strings:

  • 'PARTITION' - Creates the index as the partition index to the table enabling multiple table partitions. This option can be specified after a table has been created, and the table will be rebuilt according to the partition rule in effect.

TOCIndex