Tag Archives: sequence key

Oracle Reverse Index

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, Indexing | Tagged , , , , , , | Leave a comment