26.4.3.25 The schema_index_statistics and x$schema_index_statistics Views
These views provide index statistics. By default, rows are sorted by descending total index latency.
The schema_index_statistics and x$schema_index_statistics views have these columns:
-
table_schemaThe schema that contains the table.
-
table_nameThe table that contains the index.
-
index_nameThe name of the index.
-
rows_selectedThe total number of rows read using the index.
-
select_latencyThe total wait time of timed reads using the index.
-
rows_insertedThe total number of rows inserted into the index.
-
insert_latencyThe total wait time of timed inserts into the index.
-
rows_updatedThe total number of rows updated in the index.
-
update_latencyThe total wait time of timed updates in the index.
-
rows_deletedThe total number of rows deleted from the index.
-
delete_latencyThe total wait time of timed deletes from the index.
© 2025 Oracle
Licensed under the GPLv2 License.
