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

What is latest version of power center / power mart?

565


Explain difference between view and materialized view?

514


What are the steps involved in designing a fact table?

504


Database in use is oracle?

612


What is data warehosuing hierarchy?

589






What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?

5269


Explain swot analysis?

636


After the complete generation of a report who will test the report and who will analyze it?

559


Where we use surrogate key explain with example?

581


why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.

1548


what are relationships?

609


how much memory space occupied real time project (roughly)?

1811


Why is dimensional normalization not required?

634


Explain what are conformed dimensions?

576


Explain how are the dimension tables designed?

572