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
- 7303 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
How do I know if I have sql express or standard?
can a stored procedure call itself or recursive stored procedure? : Sql dba
how can you see all indexes defined for a table? : Sql dba
what is the difference between join and union? : Sql dba
what is self-join? : Sql dba
What is the use of sql trace?
Mention what problem one might face while writing log information to a data-base table in pl/sql?
Explain what is a view?
What does count (*) do in sql?
How do I make my sql query run faster?
Is vs as in pl sql?
How do you write an inner join query?
Define SQL and state the differences between SQL and other conventional programming Languages?
How insert into statements in sql?
What is the use of triggers?
