Recent Comments
Sam on Undo drills and view prom… Ming on Undo drills and view prom… idatcu on OBIEE Security (2) – 11g Catal… idatcu on OBIEE Security (2) – 11g Catal… Joanne on OBIEE Security (2) – 11g Catal…
Tag Archives: numeric 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
Tagged buffer busy wait, Indexing, insert, numeric key, Oracle, performance, sequence key
Leave a comment
