What is the difference between bitmap and btree index?
- 2 Answers
- 8934 Views
- CTS, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sneha latha.r
Bitmap index is used for repeating values.
ex: Gender:male/female
Account status:Active/Inactive
Btree index is used for unique values.
ex: empid.
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / amarnath
Bitmap index is used on low cardinality columns i.e less
distinct columns eg: Gender: Male/Female.
B-tree is used on high cardinality colums
eg: Student first name
| Is This Answer Correct ? | 8 Yes | 1 No |
What is Cognos script editor?
how will you remove the duplicate records from flat file without using sorter?
Which are the different editions of informatica powercenter that are available?
what is persistant cache in which situation we will use persistantcache
Explain what are the different types of transformation available in informatica.
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
What are the new features of the server manager in the informatica 5.0?
What is the difference between stop and abort in informatica
What are the main features of Oracle 8i with context to datawarehouse?
How will you update the row without using update statergy?
What are the tuning techniques you applied during your last project
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
Teradata 
