Answer Posted / 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 are the advantages of sql ? : Sql dba

1154

---

what are all the common sql function? : Sql dba

1141

---

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

1124

---

If a cursor is open, how can we find in a pl/sql block?

1252

---

Can we rollback truncate?

1083

---

What is your daily office routine?

2353

---

how to use regular expression in pattern match conditions? : Sql dba

1125

---

what is schema? : Sql dba

1163

---

what is collation? : Sql dba

1242

---

Can we use distinct and group by together?

1147

---

how to start mysql server? : Sql dba

1279

---

what is sql server agent? : Sql dba

1189

---

How do I remove duplicates in two columns?

1202

---

define sql insert statement ? : Sql dba

1110

---

what is bcp? When does it used? : Sql dba

1065

---