Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Performance GuideThe HCL OneDB™ Performance Guide describes how to configure and operate your HCL OneDB™ database server to improve overall system throughput and to improve the performance of SQL queries.
Indexes and index performance considerationsHCL OneDB™ provides several types of indexes. Some performance issues are associated with indexes.
Indexes on user-defined data typesYou 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.
Choosing operator classes for indexesFor most situations, use the default operators that are defined for a secondary-access method. However, when you want to order the data in a different sequence or provide index support for a user-defined data type, you must extend an operator class.

Choosing operator classes for indexes

For most situations, use the default operators that are defined for a secondary-access method. However, when you want to order the data in a different sequence or provide index support for a user-defined data type, you must extend an operator class.

For more information about how to extend an operator class, see HCL OneDB™ User-Defined Routines and Data Types Developer's Guide.