How many different types of indexes we have in oracle?
Answer Posted / nagaraju
We have mainly two different indexes .
Implicit index and Explicit index.
Explicit indexes are again of many types like
simple index,unique index,Bitmap index,Functional
index,Organisational index,cluster index.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Will you be able to store pictures in the database?explain.
How to use in conditions in oracle?
what is the dual table in oracle?
what are archived logs?
What is the difference between Delete, Truncate and Drop in Oracle?
What is analyze command used for?
Give the advantages and disadvantages of clusters.
What is a connect identifier?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Use of an integrity constraint is better to validate data. Explain
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What are the different types of database objects?
What is oracle instant client?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
How to display employee records who gets more salary than the average salary in the department?