There are many index types within Oracle:
B*Tree Indexes - common indexes in Oracle. They are similar construct to a binary tree; they provide fast access by key, to an individual row or range of rows, normally requiring very few reads to find the correct row. The B*Tree index has several subtypes:
▪ Index Organised Tables - A table stored in a B*Tree structure
▪ B*Tree Cluster Indexes - They are used to index the cluster keys
▪ Reverse Key Indexes - The bytes in the key are reversed. This is used to stop sequential keys being on the same block like 999001, 999002, 999003 would be reversed to 100999, 200999, 300999 thus these would be located on different blocks.
▪ Descending Indexes - They allow data to be sorted from big to small (descending) instead of small to big (ascending).