|
|
|
Only 1 serial segment mode (SRLSEG) is allowed per data file.
ROWID is used by default with c-treeDB and FairCom DB SQL and uses the SRLSEG mode. SRLSEG also imposes a performance overhead as it is a special index. This mode can be disabled on a file by file basis at file creation time.
FairCom DB IDENTITY support provides a much enhanced auto-numbering option, while retaining SRLSEG for ROWID use. From SQL this is easy to include in your tables:
CREATE TABLE mytable (name CHAR(20), age INTEGER, name_id INTEGER IDENTITY(1,1));
Temporarily Disable SRLSEG or IDENTITY
