Initially question was asked to mention the types of indexes.
Then asked about BITMAP INDEX and B-Tree Index
- 2 Answers
- 6334 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / brajesh kr.
Bitmap:- index is special kind of index that uses bitmap .
it significant space and performance advantage over
structure for such data. it is also useful for unique value
data. it use bit arrays and answer queries by performing
bitmap logical operations on these bitmap.
B-Tree:-databse server uses a b-tree strucruyre to organize
index information shows that afully developed b-treee index
is composed of that following
1.Oneroot nodes
2. Two or more branch nodes.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Can we create a trigger on view?
How do I turn a list into a table?
What is user defined functions?
Can we group by two columns in sql?
Why use triggers in sql?
What is the purpose of cursors in pl/sql?
What is the purpose of the primary key?
What does plv msg allows you to do?
Can 2 queries be executed simultaneously in a distributed database system?
what is the difference between union and union all? : Sql dba
How can a function retun more than one value in oracle with proper example?
what is the difference between clustered and non clustered index in sql? : Sql dba
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
Is stored procedure faster than query?
How sql query is executed?
