Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the difference between Bitmap and Btree index?

Answer Posted / ranvir thakor

WE can use B-Tree index where data cardinality is high and
many DML operations are performed and have many distinct
values. while Bitmap will use when have low cardinality and
less distinct value like gender column(M/F) or value does
not update frequently.

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we delete duplicate rows from flat files?

1306


Describe data concatenation?

1122


What is expression transformation?

1144


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1957


What do think which one is the better joiner or look up?

1242


Enlist some properties of sessions.

1135


Tell me about Propagate functions in informatica

976


What do you mean by enterprise data warehousing?

1105


Is it possible to define a single node as a Gateway node as well as worker node?

1182


Is stop and abort are same in informatica?

1042


Explain Dataware house architecture .how data flow from intial to end?

2643


What are the reusable transformations?

1217


What is decode in static cache?

1259


What are the features of complex mapping?

1202


what are the deliverables?in your project?

2194