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

Is pl sql a scripting language?

0 Answers  

How long will it take to learn pl sql?

0 Answers  

what is difference between procedure and function, procedure and trigger?

8 Answers   iFlex,

What is sql constant?

0 Answers  

what is the Default Libraries for Oracle Report 6i

0 Answers   IBM,




How does a self join work?

0 Answers  

How do you display "13th of November, 17 days left for month end" without hardcoding the date.

3 Answers  

Is inner join faster than left join?

0 Answers  

How do you optimize SQL queries ?

6 Answers   CarrizalSoft Technologies, Infosys, Oracle,

what is transaction? : Sql dba

0 Answers  

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

0 Answers   IBM,

Which is better cte or subquery?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories