Oracle Read – Oracle Blogs Aggregator

Bitmap indexes must never be used in OLTP systems – in other words, for tables where many insert/update/delete are done. Every insert/delete/update on such table with bitmap index locks corresponding index key until commit or rollback is performed. Take a look on the following example.  I will create a table with a single column – [...]