|
|
|
INDEXES
Syntax
I[NDEXES] [ tablename ] ;
The INDEX statement with no argument displays a list of all the user indexes in the database that are owned by the current user.
With the tablename argument, the INDEX statement displays a brief description of the indexes defined on the specified table.
The index list is sorted by table name and index name in that order.
Example
The following example uses the index list command to display lists of indexes defined on user tables.
ISQL> INDEXES
INDEXNAME TABLENAME ID OWNER TYPE ORDER COMPRESSION METHOD
--------- --------- --- ----- ---- ----- ------------ ------
sys_001_000000041 dept 33 admin U A N B
dno_idx01 emp 35 admin D A N B
sys_001_000000042 emp 34 admin U A N B
ISQL> INDEXES emp ;
INDEXNAME TABLENAME ID OWNER TYPE ORDER COMPRESSION METHOD
--------- --------- --- ----- ---- ----- ------------ ------
deptno_idx01 emp 36 admin D A N B
name_idx01 emp 34 admin D A N B
name_idx02 emp 35 admin D A N B
sys_001_000000041 emp 33 admin U A N B
