What are Bitmapped Indexes, and what are the advantage and disadvantages of it? And can I disable Index? If so how can I do that?
Printable View
What are Bitmapped Indexes, and what are the advantage and disadvantages of it? And can I disable Index? If so how can I do that?
When you have a column in which number of distinct values is small compared to number of rows in table, and if this column is used in predicate, bitmap index should be created.
Unlike regular b-tree indexes which stores rowid for each row, Bitmap index just stores a bitmap for each key value. Bitmap indexes should not be used in OLTP tables which are involved in lot many concurrent transactions as they would cause permornance problems.
can i disable index
Yes,
And what ever question you are putting up are all basic questions, which one should know if working on ORACLE. You better read the concepts guide first at http://tahiti.oracle.com and all your doubts will become clear.