B-TREE INDEX, BITMAP INDEX, REVERSE INDEX, FUNCTION-BASED INDEX, ASCENDING

How many different types of indexes we have in oracle?

Question Posted / satya krishna

24 Answers
192692 Views
IBM, TCS, I also Faced
E-Mail Answers

Answer Posted / satya krishna

B-TREE INDEX, BITMAP INDEX, REVERSE INDEX, FUNCTION-BASED INDEX, ASCENDING & DESCENDING INDEX, Cluster indexes, bitmap join indexes, text indexes, Hash cluster indexes, DOMAIN INDEXES.

Indexes are logically and physically independent of the data in the associated table.

ONCE AFTER CREATING THE INDEX ORACLE WILL AUTOMATICALLY HANDLE IT LATER.

Is This Answer Correct ?

12 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which is faster join or subquery in oracle?

995

What is partitioned table in Oracle?

1189

What is a nested table?

1061

How to assign query results to variables?

1050

Explain the use of grant option in imp command.

1030

How to specify default values in insert statement using oracle?

1104

What is private procedure oracle?

1012

What do you mean by merge in oracle?

996

Is there any function in oracle similar like group_concat of mysql?

1053

How to unlock the sample user account in oracle?

1018

What is a nvl function? How can it be used?

1031

What is dynamic proxy?

1008

How do we get field details of a table?

978

What is the recommended interval at which to run statspack snapshots, and why?

2920

What are the predefined tablespaces in a database?

1081