CODEWITHSUNDEEP
oracle-database
hydev
hydev

Reputation: 744

How to determine what index was created

I have been tasked to look at an Oracle database after a colleague has left and I would like to know if he created an index as a B-Tree or a Bitmap. Unfortunately I can't find the SQL that would tell me this.

I hope it's me being daft - can anyone help?

Upvotes: 1

Views: 96

Answers (1)

A.B.Cade
A.B.Cade

Reputation: 16905

You can query the USER_INDEXES / ALL_INDEXES / DBA_INDEXES views
It may be something like: 

SELECT index_type
FROM ALL_INDEXES
WHERE index_name = '<your_index_name>'

Upvotes: 5

Related Questions