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

Explain a private synonyms?

1043

types of indexes and the rationale behind choosing a particular index for a situation.

2510

List the types of joins used in writing subqueries?

998

Give the advantages and disadvantages of clusters.

1052

Explain the blob datatype?

1075

How different is ms access and oracle?

1043

Explain the importance of .pll extension in oracle?

1013

Why oracle is used?

1062

What is tns entry?

1157

What is pragma autonomous transaction in oracle?

1073

What is dynamic proxy?

1011

How to drop an index?

963

How a tablespace is related to data files?

1109

Explain what are clusters?

1113

What privilege is needed for a user to delete rows from tables in another schema?

1070