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.

What is form and report?

972

---

how to show all tables with 'mysql'? : Sql dba

1111

---

Explain exception handling in pl/sql?

1033

---

What is database migration?

963

---

How do you update sql?

965

---

How many indexes can be created on a table in sql?

1049

---

What does select top 1 do in sql?

1084

---

Can I join the same table twice?

1041

---

What are the operators used in select statements?

1054

---

What is group by in sql?

1080

---

How can you tell the difference between an index and a view?

930

---

What is dcl in sql?

956

---

What is an intersect?

1100

---

Are stored procedures faster than queries?

943

---

Write a sql query to convert all character to uppercase after hypen.

1434

---