How many different types of indexes we have in oracle?
- 24 Answers
- 185666 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / sudev kuma rmishra
two types
A.implicit B.explicit
A.implicit index
automatically created when we mention primary key or unique key
B.explicit index
these are created by user
and examples are
1.simple/normal index
2.composite index
3.unique index
4.bitmap index
5.partition index
6.function index
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is merge in oracle?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
How to invoke the data pump import utility?
How to create a stored program unit?
How to recover a dropped table in oracle?
How to get execution path reports on query statements?
What is difference between cartesian join and cross join?
How to insert multiple rows with one insert statement in oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What are the attributes of cursor?
what's query optimization and without use of IN AND Exist can we get another way data from query
Explain user account with reference to oracle.
Which is faster join or subquery in oracle?
What is primefaces used for?
