what is indexing ? what are different types of indexes
supported by oracle ?
- 2 Answers
- 10223 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
in general which algorithms for used?
What is the goal of optimizer?
What are snapshots? What are materialized views & where do we use them?
Explain if a flat file cotains 1000 records how can I get first and last records only?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What is analytical or analytic mean?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
How to drill through from a powerplay cube to reportnet?
What is the difference between a primary and secondary actor in use case modeling?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
Can any one explain the hierarchies level data warehousing.
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What are session timeout and application timeout? Where we have to do this process?
How to limit the max no of rows retrieved in the report?
