Database Technologies‎ > ‎Oracle‎ > ‎

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

                     SQL Server Oracle

 Clustered Index Index Organized Table (IOT)

  Non-Clustered Index 

 Default Index