-
Indexes
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?
Milinda
-
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.
-- Dilip
-
-
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.
Amar
"There is a difference between knowing the path and walking the path."
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|