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.
Resolution ClauseUse the Resolution clause in MEDIUM or HIGH mode to adjust the size of the distribution bins, and to avoid calculating data on indexes.
Using DBUPSPACE Settings to Suppress Index Information

Using DBUPSPACE Settings to Suppress Index Information

You can also prevent indexes from being used by UPDATE STATISTICS operations in sorting rows by setting the third parameter of the DBUPSPACE environment variable to a value of 1. Refer to Chapter 3 of the HCL OneDB™ Guide to SQL: Reference for information about the DBSPACETEMP and DBUPSPACE environment variables, which can restrict the system resources that are available for UPDATE STATISTICS operations. (The database server uses the storage locations that DBSPACETEMP specifies only when you use the HIGH option of UPDATE STATISTICS.)