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 there a tool to trace queries, like profiler for sql server?

1076

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2071

---

How to define an oracle sub procedure?

1049

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

1835

---

 How to use an oracle sequence generator in a mapping?

1016

---

WHAT IS ecc 6.0

2099

---

What is a snapshot log?

948

---

What is ASM (Automatic Storage Management) in Oracle?

1121

---

What is a cursor and what are the steps need to be taken?

1112

---

What is the best way to do multi-row insert in oracle?

1012

---

What is oracle and what are its different editions?

1007

---

How to use regular expression in pattern match conditions in oracle?

974

---

What's dateware house and what's clustor with practicle example

2124

---

How to drop an index in oracle?

1017

---

How to call a stored function with parameters?

968

---