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 are situations where snow flake schema is better than star schema to use and when the opposite is true?
what is the difference between aggregate table and fact table ? how do you load these two tables ?
Is it possible to have more than one row on the same table with the same foreign key?
What is the difference between snowflake and star schema?
What are Aggregate tables?
What is the difference between er modeling and dimensional modeling?
Write a short note on data warehousing & three-Tier Warehouse architecture in detail.
How to test report in reportnet?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
Explain me what are conformed dimensions?
What are snapshots? What are materialized views & where do we use them?
What is Star Schema?