Neoview Script Guide (R2.2)

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
• In the Neoview Script interface, 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.
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
FIRST_NAME ASC Other No 0 2
SQL>
• This command shows information about the materialized views of the CUSTOMERS table:
SQL>show table customers, mvs
MATERIALIZED VIEW NAME
----------------------
MYSCH.MV_CUST
SHOW TABLE Command 133