Answer Posted / warrenrame
Bitmap index is the best one. why because B-tree is suited
for unique values(eg: empid) and Bitmap is best for repeated
values(eg: gender m/f)
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How we are using this function?
What is the difference between snowflake and star schema?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
How do you setup Lo-cockpit?
Explain a mapping, session, worklet, workflow, mapplet?
How to pivot data using informatica when you have variable amount of pivot rows?
Explain what is the difference between stop and abort?
Difference between cold fusion 5 and cold fusion mx 6?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
What are the advantages of query studio compared to report studio?
What is ods (operation data source)?
How are models actually derived?
What are the different problems that ?Data mining? can solve?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
Explain reference cursor?