ALL_JSON_INDEXES

Previous Next JavaScript must be enabled to correctly display this content

3.289 ALL_JSON_INDEXES

ALL_JSON_INDEXES describes indexes on JSON data that are accessible to the current user.

Related Views

DBA_JSON_INDEXES describes all indexes on JSON data in the database.
USER_JSON_INDEXES describes indexes on JSON data that are owned by the current user. This view does not display the INDEX_OWNER column.

Column	Datatype	NULL	Description
`INDEX_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the index
`INDEX_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the index
`TABLE_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the table on which the index is defined
`TABLE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the table on which the index is defined
`COLUMN_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the JSON column on which the index is defined
`COLUMN_DATATYPE`	`VARCHAR2(13)`		Data type of the JSON column on which the index is defined
`SEARCH_INDEX`	`BOOLEAN`		Indicates whether the index is a search index (`TRUE`) or not (`FALSE`)
`FUNCTIONAL_INDEX`	`BOOLEAN`		Indicates whether the index is a function-based index (`TRUE`) or not (`FALSE`)
`COMPOSITE_INDEX`	`BOOLEAN`		Indicates whether the index is a composite index (`TRUE`) or not (`FALSE`)
`BITMAP_INDEX`	`BOOLEAN`		Indicates whether the index is a bitmap index (`TRUE`) or not (`FALSE`)
`MULTIVALUE_INDEX`	`BOOLEAN`		Indicates whether the index is a multivalue index (`TRUE`) or not (`FALSE`)
`INDEX_EXPRESSION`	`VARCHAR2(4000)`		SQL text of the index expression

Note:

This view is available starting with Oracle Database 23ai.

See Also:

"DBA_JSON_INDEXES"
"USER_JSON_INDEXES"