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
- 7275 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's the difference between inner join and left join?
what is the use of friend function? : Sql dba
What happens when a trigger is associated to a view?
Explain the difference between sql and mysql.
What are the types of views in sql?
How do I use google cloud in sql?
Which join is like an inner join?
How do I run a script in sql developer?
Which is faster count (*) or count 1?
Explain ddl statements in pl/sql?
What are the different types of dbmss?
Name the different types of indexes in sql and define them.
What is lookup table in sql?
What is embedded sql what are its advantages?
Can we use distinct and group by together?
