total indexes are in oracle is 5 1.b tree 2.bitmap 3.function

How many different types of indexes we have in oracle?

Question Posted / srinivasarao

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

Please Help Members By Posting Answers For Below Questions

What are the common oracle dba tasks?

1068

What is rowid and rownum in oracle?

951

How to write numeric literals in oracle?

1122

How to empty your oracle recycle bin?

979

How to assign query results to variables?

1007

How to sort output in descending order in oracle?

982

What are transaction isolation levels supported by oracle?

993

What are the predefined tablespaces in a database?

1003

How remove data files before opening a database?

994

What to do if the binary spfile is wrong for the default instance?

997

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

973

Explain the types of exception?

1078

Name the various constraints used in oracle?

968

What is the fastest query method to fetch data from the table?

1290

Explain an extent?

1046