Interested to Buy Any Domain ? << Click Here >> for more details...
Initially question was asked to mention the types of indexes.
Then asked about BITMAP INDEX and B-Tree Index
- 2 Answers
- 7400 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
What are operators available in sql?
How does an execution block start and end in pl sql?
How to rename a column in the output of sql query?
Is sql better than excel?
Why should I use postgresql?
What are functions in sql?
Is pl sql different from sql?
What are the topics in pl sql?
Can we insert data in view?
Why is theta join required?
Can a table contain multiple foreign key’s?
how to enter characters as hex numbers? : Sql dba
What is transaction control language (tcl)?
What is procedure in pl sql?
What is a left join?
