ALL_INDEXTYPES

ALL_INDEXTYPES displays information about the indextypes accessible to the current user.

Related Views

  • DBA_INDEXTYPES displays information about all indextypes in the database.

  • USER_INDEXTYPES displays information about the indextypes owned by the current user.

Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Owner of the indextype
INDEXTYPE_NAME VARCHAR2(30) NOT NULL Name of the indextype
IMPLEMENTATION_SCHEMA VARCHAR2(30) NOT NULL Name of the schema for the indextype implementation (that is, containing the indextype operators)
IMPLEMENTATION_NAME VARCHAR2(30) NOT NULL Name of the indextype implementation type
INTERFACE_VERSION NUMBER   Version of the indextype interface
IMPLEMENTATION_VERSION NUMBER NOT NULL Version of the indextype implementation
NUMBER_OF_OPERATORS NUMBER   Number of operators associated with the indextype
PARTITIONING VARCHAR2(10)   Kinds of local partitioning supported by the indextype:
  • NONE

  • RANGE

  • HASH

  • HASH,RANGE

ARRAY_DML VARCHAR2(3)   Indicates whether the indextype supports array DML (YES) or not (NO)
MAINTENANCE_TYPE VARCHAR2(14)   Indicates whether the indextype is system-managed (SYSTEM_MANAGED) or user-managed (USER_MANAGED)