Indexes on user-defined data types

You can define your own data types and the functions that operate on these data types. You can define indexes on some kinds of user-defined data types.

DataBlade® modules also provide extended data types and functions to the database server.

You can define indexes on the following kinds of user-defined data types:
  • Opaque data types

    An opaque data type is a fundamental data type that you can use to define columns in the same way you use built-in types. An opaque data type stores a single value and cannot be divided into components by the database server. For information about creating opaque data types, see the CREATE OPAQUE TYPE statement in the HCL OneDB™ Guide to SQL: Syntax and HCL OneDB User-Defined Routines and Data Types Developer's Guide. For more information about the data types and functions that each DataBlade module provides, see the user guide of each DataBlade module.

  • Distinct data types

    A distinct data type has the same representation as an existing opaque or built-in data type but is different from these types. For information about distinct data types, see the HCL OneDB Guide to SQL: Reference and the CREATE DISTINCT TYPE statement in the HCL OneDB Guide to SQL: Syntax.

For more information about data types, see the HCL OneDB Guide to SQL: Reference.