Lovely Gahlawat

• Jul 27th, 2007

 

Reverse -key index is index that reverse the data of the being indexed column. For example if the column value contains LOVELY, the reverse-key index will be YLEVOL.

This index very much useful where users issues the select command with where clause such as WHERE x=5 but it will not be useful for searching in range say WHERE x between 2 and 6.

Reverse key index optimises the Oracle performance in real application cluster environment.