allindexes

Syntax

allindexes [[owner_name_pattern.] table_name_pattern]

Description

Describes the indexes that it finds on the tables that match the input pattern selected from SYS.ALL_OBJECTS. When a pattern is missing, the patterns default to "%".

If passthrough is enabled, lists indexes on tables matching the pattern in the Oracle database.

For more details, see List Database Objects by Object Type.

Examples

Command> allindexes;
Indexes on system table SYS.ACCESS$:
 I_ACCESS1: non-unique range index on columns:
    D_OBJ#
    ORDER#
  1 index found.
Indexes on system table SYS.ARGUMENT$:
  I_ARGUMENT1: unique range index on columns:
    OBJ#
    PROCEDURE$
    OVERLOAD#
    SEQUENCE#
  I_ARGUMENT2: non-unique range index on columns:
    OBJ#
    PROCEDURE#
    SEQUENCE#
  2 indexes found.
…..
118 indexes found on 122 tables.