Answer Posted / satendra

Bit map Indexes are used with the columns having low
cardianality like Gender(M/F),Marital Status.The benefit of
it is that it requires a small space comapred to the case
if a B-Tree index is created on the same column of the
table.
Bit map Indexes are useful in the systems where data is not
getting updated frequently.

How do I run a query in pl sql developer?

948

---

What is delete command in sql?

1066

---

difference between anonymous blocks and sub-programs.

1090

---

What is embedded sql with example?

1000

---

How do you use collections in procedure to return the resultset?

2193

---

How do you write an inner join query?

907

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2433

---

How can I change database name in sql?

1021

---

How delete all records from table in sql?

944

---

What is pl sql block in dbms?

970

---

What is a dynamic query?

984

---

What is the function that is used to transfer a pl/sql table log to a database table?

970

---

How do you write a subquery?

978

---

How do I edit a trigger in sql developer?

948

---

Why left join is used in sql?

935

---