Initially question was asked to mention the types of indexes.
Then asked about BITMAP INDEX and B-Tree Index
- 2 Answers
- 6336 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / slokh
Bitmap index is a type of index created on the basis of the
column having low cardinality like. index created on the
column like 'gender' etc.
B-tree or binary index is created on the column contains
wide range of values like 'name' column.
note:- more than one index is created on the table.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
what is cross join? : Sql dba
how do you know if your mysql server is alive? : Sql dba
What is rowid in sql?
What is dml with example?
In what condition is it good to disable a trigger?
Is it possible to sort a column using a column alias?
what are the advantages of sql ? : Sql dba
What is pl/sql table? Why is it used?
What are the different types of a subquery?
How do you explain an index number?
what does the t-sql command ident_incr does? : Transact sql
What is the use of count (*) in sql?
What does where 1 1 mean in sql?
Explain the difference between triggers and constraints?
What is a database event trigger?
