Answer / guest

A.OLTP
B.DSS
C.Where clause has functions
D.Tables that have only one record

Answer / hitendra yadav

If there is very less cardinality (i.e. 1% of total column
values) or distinct values in column then we have to create
BITMAP index for that column like GENDER column will always
have 2 values MALE or FEMALE.

Syntex:-

Create bitmap index index_name on table_name(column_name);

What is full join in sql?

0 Answers  

---

what is the sql query to display current date? : Sql dba

1 Answers  

---

How to run sql statements through the web interface?

0 Answers  

---

what is the difference between cluster and non cluster index? : Sql dba

0 Answers  

---

Give which cursor is better for better performance means type of cursors?

2 Answers  

---

What will be the output of the following String S = 1+2+"abc" S = ? String S1 = 1+2+"abc"+5+6 S1 = ?

1 Answers   ABC,

---

Can I join the same table twice?

0 Answers  

---

how is exception handling handled in mysql? : Sql dba

0 Answers  

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

0 Answers  

---

Differentiate between sga and pga.

0 Answers  

---

how many ways to get the current time? : Sql dba

0 Answers  

---

What is the basic form of sql query?

0 Answers  

---