what is indexing ? what are different types of indexes
supported by oracle ?
Answers were Sorted based on User's Feedback
Answer / sabeena
Indexing is sorting data, used for fast retrival.
Different types are
b tree index
function based index
reverse key index
bitmap index
compressed index
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / msb.dwh
INDEX R USED FOR FASTRETRIVING OF DATA NOT ONLY FAST BUT
ALSO EFFICTIVE DATA
TYPES OF INDEX R B-TREE AND BIT-MAP
| Is This Answer Correct ? | 4 Yes | 0 No |
What is index awareness in universe?
How to get the first 100 rows from the flat file into the target?
What are the differences between star and snowflake schema?
What are session timeout and application timeout?
How many repositories can we create in Informatica?
Explain what does level of granularity of a fact table signify?
What are situations where snowflake schema is better than star schema when the opposite is true?
What is degenerate dimension table?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What are the different methods of loading dimension tables?
Why is chameleon method used in data warehouse?
What is the capacity of power cube?