The first part of the dbschema output describes which data distributions have been created for the specified table. The name of the table is stated in the following example:
Distribution for cathl.invoices.invoice_num
The output is for the invoices table, which is owned by user cathl. This data distribution describes the column invoice_num. If a table has distributions that are built on more than one column, dbschema lists the distributions for each column separately.
The date on which the distributions are constructed is listed. In this example, the date is 03/10/2001, which is the date when the UPDATE STATISTICS statement that generated the distributions was executed. You can use this date to tell how outdated your distributions are. Although the system records the date, it does not record the time.
The last line of the description portion of the output describes the mode (medium or high) in which the distributions were created, and the resolution. If you create the distributions with medium mode, the confidence of the sample is also listed. For example, if the UPDATE STATISTICS statement is executed with high mode with a resolution of 10, the last line appears as the following example shows:
High Mode, 10.000000 ResolutionHome | [ Top of Page | Previous Page | Next Page | Contents | Index ]