Tag Archives: numeric key

Oracle Reverse Index

Posted on March 25, 2017 by idatcu

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 buffer busy wait, Indexing, insert, numeric key, Oracle, performance, sequence key | Leave a comment

	idatcu on OBIEE Security (2) – 11g Catal…
	idatcu on OBIEE Security (2) – 11g Catal…
	Joanne on OBIEE Security (2) – 11g Catal…
	Mohd Iqbal Wani on OBIEE Security (2) – 11g Catal…
	Oracle Reverse Index… on Buffer Busy Waits – Reve…

Tag Archives: numeric key

Oracle Reverse Index

Categories

Recent Posts

Archives

Recent Comments

Meta

Blog Stats