How many different types of indexes we have in oracle?

Answer Posted / srinivasarao

total indexes are in oracle is 5
1.b tree
2.bitmap
3.function_based
4.domain
5.ascending or descending

Is This Answer Correct ?    27 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How translate command is different from replace?

543


How to put more than 1000 values into an oracle in clause?

586


How do we represent comments in oracle?

627


Explain the features of oracle?

596


What is concurrency in oracle?

542






How to display row numbers with the records?

584


Use of an integrity constraint is better to validate data. Explain

543


Can you assign multiple query result rows to a variable?

547


What is transaction control statement and how many types of transaction control statement in Oracle?

562


Difference between pre-select and pre-query

575


Which is better Oracle or MS SQL? Why?

5433


What is rich query?

540


How to loop through data rows in the implicit cursor?

539


Explain how you would restore a database using RMAN to Point in Time?

1632


What is the difference between sharding and replication?

475