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);

How do I get sql certification?

975

---

What are the methods of filing?

935

---

How do you declare a user-defined exception?

1029

---

Why is stored procedure faster than query?

963

---

What are operators available in sql?

1051

---

What are joins in sql?

1048

---

Does view store data in sql?

969

---

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

1440

---

Does sap use sql?

996

---

Which data type is a composite type?

991

---

what are wild cards used in database for pattern matching ? : Sql dba

1145

---

How do you update sql?

983

---

What is difference between nchar and nvarchar?

1029

---

Is merge a dml statement?

983

---

what is heap table? : Sql dba

1108

---