Oracle Managing Indexes

As defined by oracle we have following indexes.

1) B-Tree Index : By far the most common one.

2) B-Tree Cluster : Index defined for cluster.

3) Hash Cluster : Index defined for Hash Cluster.

4) Global and Local Indexes : Relate to partitioned table and indexes.

5) Reverse key Indexes : most usefulll for RAC

6) Function-Based

7) Domain indexes.

We will mostly deal with B-Tree Index