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 are the different types of sql commands?
what is auto increment? : Sql dba
How do I sort a table in sql?
Whis is not false in primary key?
What are the types of triggers in sql?
Which join condition can be specified using on clause?
Can delete statement be rollbacked?
What are the triggers associated with image items?
How many row comparison operators are used while working with a subquery?
Explain two easy sql optimizations.
Can we perform dml in function?
Is and as keyword in pl sql?
How do I run pl sql in sql developer?
What are sql triggers used for?
How many triggers can be applied on a table?