What is a reverse key index and it's real time usage

Questions by subbaraovangalli   answers by subbaraovangalli

Showing Answers 1 - 1 of 1 Answers

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.