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 asqueryable?
What is hibernate and its relation to sql?
What are basic techniques of indexing?
How do I add a database to sql?
What is record in pl sql?
What is a procedure in pl sql?
What are the main features of cursor?
Differentiate pl/sql and sql?
What is the current version of postgresql?
what is a trigger in mysql? Define different types of trigger. : Sql dba
What is the purpose of a secondary key?
what is an extent ? : Sql dba
How many triggers can be applied to a table?
What does plv msg allows you to do?
Is sql microsoft?