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 is the example of procedure?

920

---

Can we call stored procedure in function?

952

---

How we can update the view?

1043

---

how to analyze tables with 'mysqlcheck'? : Sql dba

1004

---

What will you get by the cursor attribute sql%notfound?

1051

---

What is sql scripting?

1103

---

How do you explain an index number?

1091

---

What are the different types of database management systems?

994

---

How do you clear the screen in sql?

1064

---

What is the difference between subquery and correlated query?

1054

---

What are the triggers associated with image items?

1034

---

Is it possible to link two groups inside a cross products after the cross products group has been created?

1000

---

Can you do multiple joins in sql?

1036

---

how to use in conditions? : Sql dba

1007

---

What are the various levels of constraints?

1119

---