sqlstatistics

Syntax

sqlstatistics [[owner_name_pattern.]table_name_pattern]

Description

Prints results of an ODBC call to SQLStatistics.

Example

Command> sqlstatistics dual;

  TABLE_QUALIFIER:    <NULL>
  TABLE_OWNER:        SYS
  TABLE_NAME:         DUAL
  NON_UNIQUE:         <NULL>
  INDEX_QUALIFIER:    <NULL>
  INDEX_NAME:         <NULL>
  TYPE:               0
  SEQ_IN_INDEX:       <NULL>
  COLUMN_NAME:        <NULL>
  COLLATION:          <NULL>
  CARDINALITY:        1
  PAGES:              <NULL>
  FILTER_CONDITION:   <NULL>
  TT_INDEX_USAGE:     <NULL>

1 row found.