Rows insert/update/delete and BITMAP index
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 – [...]
Leave a Reply