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`)