Distribution information for tables in dbschema output
The dbschema -hd command with the name of the table retrieves the distribution information that is stored for a table in a database. If you specify the ALL keyword for the table name, the distributions for all the tables in the database are displayed.
- Virtual Index Interface (VII) or function indexes
- Indexes on columns of user-defined data types
- Indexes on columns of built-in opaque data types (such as BOOLEAN or LVARCHAR)
For information about using the UPDATE STATISTICS statement, see the HCL OneDB™ Guide to SQL: Syntax.
- Distribution description
- Distribution information
- Overflow information
Each section of dbschema output is explained in the following sections. As an example, the discussion uses the following distribution for the fictional table called invoices. This table contains 165 rows, including duplicates.
dbschema -hd invoices -d pubs_stores_demo