To display the distribution information that is stored for a table in a database, use the -hd option with the name of the table. If you specify the ALL keyword for the table name, the distributions for all the tables in the database are displayed.
Distribution information is stored only if you have run the UPDATE STATISTICS...MEDIUM or HIGH statement for one or more columns of a table. For information about the UPDATE STATISTICS statement, refer to the IBM Informix: Guide to SQL Syntax.
The output of dbschema for distributions is provided in the following parts:
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.
You can generate the output for this discussion with a call to dbschema that is similar to the following example:
dbschema -hd invoices -d pubs_stores_demoHome | [ Top of Page | Previous Page | Next Page | Contents | Index ]