Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CREATE INDEX statementUse the CREATE INDEX statement to create an index for one or more columns in a table, or on values returned by a UDR that uses column values as arguments.
FRAGMENT BY Clause for IndexesUse the FRAGMENT BY clause to create a detached index and to define its fragmentation strategy across dbspaces or partitions.
Restrictions on fragmentation expressions

Restrictions on fragmentation expressions

The following restrictions apply to the expression:

Each fragment expression can contain columns only from the current table, with data values only from a single row.
The expression must return a BOOLEAN (true or false) value.
No subqueries, aggregates, user-defined routines, nor references to fields of a ROW type column or sequence objects are valid.
The built-in CURRENT, SYSDATE, TODAY, SITENAME, DBSERVERNAME, CURRENT_USER, or USER functions are not valid.
The DEFAULT_ROLE and CURRENT_ROLE operators are not valid.

The columns contained in the fragment expression for unique indexes must be the same as the indexed columns or a subset of the indexed columns.

The restrictions listed above also apply to indexes that use a LIST fragmentation strategy.