Categories
-
Recent Posts
Archives
Recent Comments
Meta
Blog Stats
- 13,451 hits
Tag Archives: performance
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
