How many different types of indexes we have in oracle?

Answer Posted / rajesh

Mainly Two type of Index in Oracle.
1:-> Logical
2:-> Physical

1:-> Unique,Non Unique,Function
2:-> B-Tree & Bitmap

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the use of analyse option in exp command.

590


What is oracle in java?

524


How to bring a tablespace offline?

545


How to write a left outer join with the where clause in oracle?

633


what is the scripts in data base?

1607






How to name query output columns in oracle?

692


What is the difference between a hot backup and a cold backup in oracle?

579


How to rebuild an index in oracle?

558


How to use values from other tables in update statements using oracle?

570


What are the types of partitions in oracle?

543


What are the general rules on data consistency?

589


In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1366


What are the different types of synonyms?

603


Is oracle the best database?

522


What is the difference between a primary key & a unique key?

590