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

	idatcu on Oracle: Partition by List Sub-…
	Nazrul on Oracle: Partition by List Sub-…
	Oracle Indexing \| BI… on Oracle Function Based Ind…
	Oracle Indexing \| BI… on Oracle Index Organized Ta…
	Sam on Undo drills and view prom…

Tag Archives: numeric key

Oracle Reverse Index

Categories

Recent Posts

Archives

Recent Comments

Meta

Blog Stats