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

can u any challenge your project?

2033


What are the informatica performance improvement tips

1093


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2237


What is a repository? And how to add it in an informatica client?

1149


Explain the informatica workflow?

1074


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2079


Explain your project of banking domian.

1652


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

1837


What is joiner transformation?

1010


What are different types of transformations available in informatica?

993


What is a rank transform?

1086


What is a surrogate key?

1083


What are junk dimensions?

1072


Slowly changing dimensions, types and where will you use them

1714


What is Data Caches size?

1091