Monthly Archives: March 2017

Buffer Busy Waits – Reverse Key Index – Demo

We discussed earlier about indexing, and specifically reverse key indexing. I mentioned that is a solution for buffer busy waits on numerical consecutive inserted keys (like the sequence based generated ones) . This post will test that solution. For regular … Continue reading

Posted in DW, Indexing, OBIEE | 1 Comment

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