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 sqlca in db2?

889

---

What is varchar sql?

1058

---

How can use stored procedures in sql?

1079

---

how to present a past time in hours, minutes and seconds? : Sql dba

943

---

How can I get the number of records affected by a stored procedure?

999

---

What are the different types of database management systems?

949

---

how to escape special characters in sql statements? : Sql dba

967

---

Can we alter stored procedure?

942

---

What is faster join or subquery?

959

---

Define join and name different types of joins?

957

---

What are all the different normalizations?

969

---

how to create a test table in your mysql server? : Sql dba

942

---

What is union, minus and interact commands?

1213

---

What is the largest value that can be stored in a byte data field?

956

---

Can a select statement fire a trigger?

1096

---