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 / kishore

b-tree indexes are used usuall when we have too many
distinct columns and for high cardinaties . and bitmap
indexex are used for low cardinaties usually when we have
repeated columns.

Is This Answer Correct ?    18 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the shared cache and re-cache?

1067


Explain the scenario which compels informatica server to reject files?

1112


What are the types of caches in lookup? Explain them.

933


Explain pushdown optimization and types in informatica

1034


What is the surrogate key?

1177


Under what conditions selecting sorted input in aggregator will still not boost session performance?

1045


Clarify the aggregator change?

989


What is the need of an ETL tool?

1046


What is the difference between informatics 7x and 8x and what is latest version?

1045


What do you understand by term role-playing dimension?

1004


What is aggregator transformation in informatica?

909


Where is metadata stored?

1060


How to load the data from a flat file into the target where the source flat file name changes daily?

1022


What differs when we choose the sorted input for aggregator transformation?

983


Name the different lookup cache(s)?

1173