Neoview Command Interface (NCI) Guide (R2.3)

table-name
specifies the name of a table. If you do not fully qualify the table-name, NCI uses the
current schema.
materialized-view-name
specifies the name of a materialized view. If you do not fully qualify the
materialized-view-name, NCI uses the current schema.
INDEXES
displays information about the indexes associated with the specified table or materialized
view. The displayed information about each index includes:
Name of each column in the index• Column name
Storage and retrieval order, either ascending or
descending, for rows in the index
• Order
Type of index (clustered, hashed, or other)• Index type
Whether the column or set of columns that comprise
the index do not contain more than one occurrence of
the same value or set of values
• Uniqueness
Number of unique values in the index• Cardinality
Position of the column within the index• Position
For more information about indexes, see the Neoview SQL Reference Manual.
MVS
displays a list of the materialized views associated with the specified table or materialized
view.
ALL
displays information about indexes, materialized views, and synonyms for a specified table
or materialized view.
SYNONYMS
displays a list of the synonyms associated with the specified table or materialized view.
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• You can execute this command only in SQL mode.
• If the SET TIMING command is set to ON, the elapsed time information is displayed.
Examples
• This command shows information about three indexes of the EMPLOYEE table:
SQL>show table persnl.employee, indexes
COLUMN NAME ORDER INDEX TYPE UNIQUE CARDINALITY POSITION
------------------- ----- ---------- ------ ----------- --------
Index 1 :EMPLOYEE
-----------------
EMPNUM ASC Other Yes 0 1
Index 2 :XEMPDEPT
-----------------
DEPTNUM ASC Other No 0 1
Index 3 :XEMPNAME1
-----------------
LAST_NAME ASC Other No 0 1
SHOW TABLE Command 147