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

where to store informatica rejected data?

1093


difference between repository database and repository service?

1150


How can you increase the performance in joiner transformation?

1189


What are the transformations that are not supported in mapplet?

1022


What do you mean by worklet?

1064


What is the need for an etl tool?

1067


What do mean by local and global repository?

1225


Explain in detail about scd type 1 through mapping.

1551


What is sequence generator transformation in informatica?

1075


What is domain in terms of informatica?

1007


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2280


What are the uses of etl tools?

1123


Design time, run time. If you don't create parameter what will happen

1835


What is a sequence generator transformation?

1017


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1129