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.
Improving individual query performanceYou can test, monitor, and improve queries.
Optimize queries for user-defined data typesQueries that access user-defined data types (UDTs) can take advantage of the same performance features that built-in data types use.
User-defined statistics for UDTsBecause information about the nature and use of a user-defined data type (UDT) is not available to the database server, it cannot collect distributions or the colmin and colmax information (found in the syscolumns system catalog table) for a UDT. Instead, you can create a special function that populates these statistics.

User-defined statistics for UDTs

Because information about the nature and use of a user-defined data type (UDT) is not available to the database server, it cannot collect distributions or the colmin and colmax information (found in the syscolumns system catalog table) for a UDT. Instead, you can create a special function that populates these statistics.

The database server runs the statistics collection function when you execute UPDATE STATISTICS.

For more information about the importance of updating statistics, see Statistics held for the table and index. For information about improving performance, see Updating statistics for columns with user-defined data types.