How to see a list of all the indexes (including implicit ones) in SQL*Plus?

Viewed 52447

Is there some way to get a list of all the indexes on a particular table using SQL*Plus?

I created a table

CREATE TABLE temp(
id NUMBER PRIMARY KEY,
name VARCHAR2(20));

There should be an implicit index created on the primary key (id). How can I see that index?

SELECT * FROM all_indexes WHERE table_name = 'temp';

gives

no rows selected

4 Answers

If you want to display all indexing in a database you can try.

use information_schema;
SELECT * FROM statistics;
Related