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 |
How can Oracle Materialized Views be used to speed up data warehouse queries?
What is meant by metadata in context of a data warehouse and how it is important?
What are the different ways to represent the loading of dimension tables?
2.What is staging area ?
4 Answers HCL, IBM, iFlex, TCS,
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What are session timeout and application timeout? Where we have to do this process?
What are the data marts?
How many project sources we can create in metadata?
What are the mapping paramaters and maping variables?
Explain what are components of reportnet?
List down some of the real time data-warehousing tools?
Data WareHousing course in noida