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
- 7291 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 is heap table? : Sql dba
What information is needed to connect sql*plus an oracle server?
Where do we use pl sql?
What is flag in sql?
Is not equal in sql?
What is vector point function?
What is asqueryable?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
When should I use nosql database?
What is sql select statement?
What is the difference between cross join and natural join?
What is sql constant?
What is a record in pl/sql?
Explain some predefined exceptions.
What is sql rowcount?
