Tag Archives: numeric key

Oracle Reverse Index

Posted on March 25, 2017 by

This is one of the least used Oracle indexes I’ve encountered in a data-warehousing environment. However, a very good instrument in performance problems on OLTPs. To understand a reverse key index, we must first look at the regular b-tree index … Continue reading →

Posted in DW | Tagged , , , , , , | Leave a comment