what is indexing ? what are different types of indexes
supported by oracle ?
Answer Posted / 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 |
Post New Answer View All Answers
What are aggregate transformation?
How can you implement many relations in star schema model?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
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 is freehand sql?
What is mean by aggregate aware?
What is Discover and Execute in XMLA?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
Explain what are the possible data marts in retail sales?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
What are the various methods of getting incremental records or delta records from the source systems?
What is data warehosuing hierarchy?