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 primefaces used for?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
List out the types of joins.
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.
does the query needs a hint to access a materialized view?
What are the extensions used by oracle reports?
Explain about your project and its relation to the current job position you are applying to?
When do you get a .pll extension in oracle?
How do you store pictures in a database?
Can we store pictures in the database and if so, how it can be done?
Why packages are used in oracle?
What is a dead lock in oracle?
What is an oracle database table?
What is save point in oracle database?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.