Interested to Buy Any Domain ? << Click Here >> for more details...
what is the bitmap index?
- 3 Answers
- 7062 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / a g srikanth
Bitmap Index is an index that can be used on low
cardinality columns with a large number of rows. Low
cardinality columns are the ones with less number of
distinct values (eg.gender columns with just two distinct
values Male & Female).
Bitmap indexes are also useful in DWH applications where a
large table is joined with many small tables in a
denormalized star schema.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / daid kumar
bitmap Index is Used mainly in decision support systems
because it returns value in bit like 0 and 1.
Example
CREATE BITMAP JOIN INDEX <index_name>
ON <table_name> (<table_name.column_name>)
FROM <table_name, table_name>
WHERE <join_condition>
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kamala k n
bit map index created on low cardinality columns
| Is This Answer Correct ? | 0 Yes | 0 No |
what is the difference between table and veiw?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How a tablespace is related to data files?
Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?
Can we insert data in view oracle?
How to get execution statistics reports on query statements?
How to start instance with a minimal initialization parameter file?
how to retrieve 1st and last row of table without using group functions??
What is open database communication (odbc) in oracle?
When do I need to use a semicolon vs a slash in oracle sql?
Explain the function of optimizer in oracle?
how to get last monday of a month?
Oracle General 
