How many different types of indexes we have in oracle?
Answer Posted / ananthram
Just and Addition to the above discussion.
I cant agree completely with answer #3 when it says
"This index is not Unique index "
Because Oracle makes sure that the uniqueness is maintained
in case of Primary and unique key by imposing UNIQUE INDEX
on it.
So I find it difficult when someone says that the implicit
indexes created by oracle while the creation of PK and UK
are not UNIQUE indexes.
Is This Answer Correct ? | 32 Yes | 9 No |
Post New Answer View All Answers
What are the predefined tablespaces in a database?
how to join query for one source type is oracle another source type is sql server ?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
What is raw datatype?
How to set a transaction to be read only in oracle?
What do you mean by redo log file mirroring?
How to bring a tablespace online?
What is a nvl function? How can it be used?
Explain the use of Merge statement in oracle 11g
What is bind variable in oracle 11g?
Write a syntax for update query in oracle?
What are the advantages of oracle?
What is save point in oracle database?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How to export your own schema?