Initially question was asked to mention the types of indexes.
Then asked about BITMAP INDEX and B-Tree Index
- 2 Answers
- 6539 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
Define select, insert, create, delete, update, drop keywords
What is the syntax to add a record to a table?
Is sql low level language?
write an sql query to find names of employee start with 'a'? : Sql dba
what are local and global variables and their differences? : Sql dba
How insert into statements in sql?
Which kind of parameters cannot have a default value in pl sql?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
How can you know that statistics should be updated?
Is sql a oracle?
How many types of functions are there in sql?
What is bulk collect in pl sql?
Is delete faster than truncate?
Does sql support programming?
Can a foreign key be a duplicate?
