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
- 7167 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 makes a good primary key?
How do I edit a stored procedure?
Can a foreign key have a different name?
What is natural join in sql?
how to rename an existing column in a table? : Sql dba
What is sql comments?
What is sql and also describe types of sql statements?
What is the difference between numeric and autonumber?
What is the difference between a procedure and a function?
What has stored procedures in sql?
what happens if null values are involved in expressions? : Sql dba
How do I upgrade sql?
How exception is different from error?
What is the process of copying data from table a to table b?
What port does sql server use?
