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 basic structure of an sql?
Is null operator in sql?
Can there be 2 primary keys in a table?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is the source code of a program?
What is the difference between null value, zero, and blank space?
What are the types of subqueries?
What is sqlca in powerbuilder?
What does truncate mean in sql?
What is foreign key in sql with example?
What is consistency?
How do I truncate a word?
Is sql a scripting language?
What is the best partition size for windows 10?
How to create an array in pl/sql?