Answer Posted / 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 |
Post New Answer View All Answers
What is the maximum limit on the number of columns in a table?
How to assign values to variables?
Is postgres faster than oracle?
What is program global area (pga) in oracle?
is there a tool to trace queries, like profiler for sql server?
what are actual and formal parameters?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to change system global area (sga) in oracle?
What is null value in oracle?
Explain enable novalidate constraint.
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How would you begin to troubleshoot an ORA-3113 error?
Explain what are the characteristics of data files?
what is the difference between data migration and production migration.
Where are the settings stored for each instance in oracle?