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™.
UPDATE STATISTICS statementUse the UPDATE STATISTICS statement to update system catalog information that the query optimizer uses for operations on objects in the local database. The UPDATE STATISTICS statement is an extension to the ANSI/ISO standard for SQL.
Updating Statistics for Columns of User-Defined Types To calculate statistics for a column of a user-defined data type (UDT), you must use either the UPDATE STATISTICS MEDIUM FOR TABLE or the UPDATE STATISTICS HIGH FOR TABLE statement.
Requirements for Statistics on Opaque Columns

Requirements for Statistics on Opaque Columns

UPDATE STATISTICS can collect statistics for columns of user-defined opaque data types only if support routines for statcollect( ), statprint( ), and the selectivity functions are defined for the UDTs. You must also hold Usage privilege on these routines.

In some cases, UPDATE STATISTICS also requires an sbspace as specified by the SYSSBSPACENAME configuration parameter. For information about how to provide statistical data for a column whose data type is a UDT, refer to the HCL OneDB™ DataBlade® API Programmer's Guide. For information about SYSSBSPACENAME, refer to your HCL OneDB Administrator's Reference.