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: performance
Oracle Bitmap Index
Common usage of Bitmap Indexes is a data warehousing environment. This implies large amounts of data, high level of ad-hoc queries but a low level of concurrent DLM transactions. Why to use? reduced response time reduced storage requirements compared to other … Continue reading
Posted in DW, Oracle DB Intro
Tagged bitmap, bitmap merge, data warehouse, datawarehouse, DW, Indexing, low cardinality index, Oracle, performance, SQL
Leave a 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
Tagged buffer busy wait, Indexing, insert, numeric key, Oracle, performance, sequence key
Leave a comment
