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 is view? : Sql dba

0 Answers  


what is External tables? explain with examples

2 Answers   TCS,


What is the use of pl/sql table?

0 Answers  


Is postgresql a nosql database?

0 Answers  


Explain the uses of a database trigger?

0 Answers  


Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  


Difference between inline query and stored procedure?

4 Answers   Bharat, Microsoft,


Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

3 Answers   eBay,


What is a .db file?

0 Answers  


What is Histogram?

0 Answers   NIIT,


Does sqlite need a server?

0 Answers  


What is indexing oracle sql?

0 Answers  


Categories