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

select sal from emp group by sal

3 Answers   TCS,

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

which will default fire first  statement level trigger or row level trigger

2 Answers   Cap Gemini, Data Vision,

How many joins can you have in sql?

0 Answers  

wa procedure to return the month and the no'f developers joined in each month.

4 Answers   Fidelity,




which operator is used in query for pattern matching? : Sql dba

0 Answers  

What is a data definition language?

0 Answers  

What are tables in sql?

0 Answers  

How packaged procedures and functions are called from the following?

2 Answers  

What is cross join sql?

0 Answers  

What is the use of sql trace?

0 Answers  

What is thread join () in threading?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories