1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

When do we create bitmap indexes

Question Posted / guest

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

how to check the 3rd max salary from an employee table?

23 Answers   IBM,

Can we commit inside a trigger?

0 Answers  

What is a sql select statement?

0 Answers  

How is data stored on a disk?

0 Answers  

Which normal form is best?

0 Answers  




Does mysql_real_escape_string prevent sql injection?

0 Answers  

What is sql and its types?

0 Answers  

What is a sql driver?

0 Answers  

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

0 Answers  

What is a parameter query?

0 Answers  

Why is normalization important?

0 Answers  

Is left join same as join?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories