what is indexing ? what are different types of indexes
supported by oracle ?

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


Please Help Members By Posting Answers For Below Questions

Explain dimensional modelling?

538


What are the different types of fact tables used in data warehousing?

550


What are the mapping paramaters and maping variables?

560


Suggest a good author for hyperion in data warehousing?

552


What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

559






Explain what are the different types of join operations?

530


What is a hash cluster?

511


What are the main steps to build the data warehouse?

649


Explain why should you put your data warehouse on a different system than your oltp system?

507


Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

549


what is parallel query?

1620


What are components of reportnet?

594


How can we do data cleaning?

580


Explain what is the advantages data mining over traditional approaches?

574


Explain hybrid slowly changing dimension?

558