Initially question was asked to mention the types of indexes.
Then asked about BITMAP INDEX and B-Tree Index
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 the use of function in sql?
Does sql profiler affect performance?
what is the difference between char and varchar data types? : Sql dba
how is exception handling handled in mysql? : Sql dba
How to fetch alternate records from a table?
What is sql in java?
Where is sql database stored?
What is sqlca in powerbuilder?
How can you fetch common records from two tables?
What does varchar include?
What is the difference between execution of triggers and stored procedures?
What do you understand by pl/sql packages?
Is sqlite good enough for production?
Explain unique key in sql.
Can a key be both primary and foreign?