Initially question was asked to mention the types of indexes.
Then asked about BITMAP INDEX and B-Tree Index
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 schema-level triggers?
what are the different type of normalization? : Sql dba
What does count (*) mean?
What is the difference between nvl function, ifnull function, and isnull function?
what is a database transaction? : Sql dba
What is the most important ddl statements in sql are?
What is mutating error in pl sql?
Is inner join faster than left join?
Explain what is dbms?
What is sql table?
what is the difference between sql and t-sql? : Transact sql
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What is the primary use of normalization?
Explain about various levels of constraint.
What is rollback?