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.
Fragmentation of Indexes on Temporary Tables

Fragmentation of Indexes on Temporary Tables

You can fragment a unique index on a temporary table only if the underlying table uses an expression-based distribution scheme. That is, the CREATE TEMP TABLE statement that defines the temporary table must specify an explicit expression-based distribution scheme. (Fragmentation of the index by ROUND ROBIN is not supported, and fragmentation by LIST or by INTERVAL is automatic, for a unique index on a table that uses a list or interval storage partitioning strategy.)

If you try to create a fragmented, unique index on a temporary table for which you did not specify a fragmentation strategy when you created the table, the database server creates the index in the first dbspace that the DBSPACETEMP environment variable specifies. For more information on the DBSPACETEMP environment variable, see the HCL OneDB™ Guide to SQL: Reference.

For more information on the default storage characteristics of temporary tables, see Where temporary tables are stored.