How many different types of indexes we have in oracle?

Answer Posted / vicky

Mainly indexes are 3 types:
1:-functional based index
2:-bit map index
3:-b-tree index

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of cluster table in Oracle?

580


How to define an anonymous procedure without variables?

553


What is ADDM Advisor in Oracle?

668


How to get execution statistics reports on query statements?

572


Explain what does a control file contain?

614






What is the sid in oracle?

538


what is reindexing?

1182


What is program global area (pga) in oracle?

609


How a database is related to tablespaces?

582


What is a trigger and what are its types?

617


Explain self joins in oracle?

564


Explain the difference between sap and oracle?

577


How to define a sub function?

671


How to upsert (update or insert into a table)?

541


What are the uses of a database trigger?

522