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

What is linq to sql?

0 Answers  

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

5 Answers   HCL, JPMorgan Chase,

Is record in pl sql?

0 Answers  

In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,

what are the forced views

6 Answers   Hexaware, TCS,




What is keys and its types?

0 Answers  

what eliminate duplicate without using roenum and not

5 Answers   Matrix,

what is autonomouse transaction?

3 Answers   Oracle,

What is dcl in sql?

0 Answers  

Is it possible to sort a column using a column alias?

0 Answers  

What are data types in pl sql?

0 Answers  

What is RAC in oracle?

7 Answers   MCN Solutions,

For more SQL PLSQL Interview Questions Click Here
Categories