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 is the difference between PFILE and SPFILE in Oracle?
How different is ms access and oracle?
Why we use bulk collect in oracle?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
State and explain about oracle instance?
What is hash cluster in oracle?
How to define an oracle sub procedure?
How to compare dates in oracle sql?
Explain a segment?
How much memory your 10g xe server is using?
What is oracle instant client?
Describe varray?
What is ceil and floor in oracle?
What are the attributes of the cursor?
How to export your connection information to a file?