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 Informix Guide to SQL: Syntax and HCL Informix 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 Informix Guide to SQL: Reference and the CREATE DISTINCT TYPE statement in the HCL Informix Guide to SQL: Syntax.

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


Copyright© 2019 HCL Technologies Limited