Bitmap index is the best one. why because B-tree is suited for unique valu

Which kind of index is preferred in DWH?

Question Posted / warrenrame

Answer Posted / warrenrame

Bitmap index is the best one. why because B-tree is suited
for unique values(eg: empid) and Bitmap is best for repeated
values(eg: gender m/f)

Is This Answer Correct ?

6 Yes

1 No

Please Help Members By Posting Answers For Below Questions

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

2065

Explain er diagram?

935

Where the data cube technology is used?

907

What is data warehouse architecture?

989

Can any one explain the hierarchies level data warehousing.

925

Explain about core dimension,

921

What is hybrid slowly changing dimension?

987

Tell me what is degree of a relation?

935

What are the various file formats involved in reportnet?

911

What are algorithms provided by Microsoft in SQL Server?

1983

Explain what is metadata reporter?

906

Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....

2283

What is scd1 , scd2 , scd3?

1034

what are different storage options supported by oracle ?

2038

How to design file watch jobs?

927