1.B-tree indexes: B-tree indexes have the following subtypes: I

How many different types of indexes we have in oracle?

Question Posted / shankar

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

Answer Posted / shankar

1.B-tree indexes:
B-tree indexes have the following subtypes:
Index-organized tables
Reverse key indexes
Descending indexes
B-tree cluster indexes
2.Bitmap and bitmap join indexes
3.Function-based indexes
4.Application domain indexes

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to use null as conditions in oracle?

1075

What do you mean by a database transaction & what all tcl statements are available in oracle?

989

What is bind variable in oracle 11g?

1037

Please explain oracle data types with examples?

1060

How to divide query output into groups in oracle?

985

When do you get a .pll extension in oracle?

1144

What do you mean by group by clause?

1042

How to declare a local variable?

1109

What is raw datatype in oracle?

1127

what is a Nested Loop join?

2104

How many anonymous blocks can be defined?

1178

What is a select query statement in oracle?

959

How to use "startup" command to start default instance?

1025

How to create a new user account in oracle?

1012

How to connect the oracle server as sysdba?

1074