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 when you upgrade the database serverWhen you upgrade a database to use with a newer database server, you can use the UPDATE STATISTICS statement to convert the indexes to the form that the newer database server uses.

Updating statistics when you upgrade the database server

When you upgrade a database to use with a newer database server, you can use the UPDATE STATISTICS statement to convert the indexes to the form that the newer database server uses.

You can choose to convert the indexes one table at a time or for the entire database at one time. Follow the conversion guidelines that are outlined in the HCL OneDB™ Migration Guide.

Migration to a newer database server is the only context in which the UPDATE STATISTICS statement causes table indexes to be implicitly dropped and re-created.