When do we create bitmap indexes

Answers were Sorted based on User's Feedback



When do we create bitmap indexes..

Answer / guest

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

Is This Answer Correct ?    19 Yes 2 No

When do we create bitmap indexes..

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

Is This Answer Correct ?    17 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What are the advantages of sql? Explain

0 Answers  


How can I speed up sql query?

0 Answers  


Explain the savepoint statement.

0 Answers  


How will you select unique values from a list of records?

7 Answers   Cap Gemini,


how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?

3 Answers   3i Infotech,


How many rows will return from dual table?

4 Answers   Fujitsu,


When can we use the where clause and the having clause?

0 Answers  


What is difference between sql function and stored procedure?

0 Answers  


in materialized view the structure will create immediately or not?

2 Answers   iFlex,


what are the different tables present in mysql? : Sql dba

0 Answers  


what is query cache in mysql? : Sql dba

0 Answers  


I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.

3 Answers  


Categories