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
How to bring a tablespace online?
How much memory your 10g xe server is using?
How many types of auditing in Oracle?
What are the logical operations?
How to select all columns of all rows from a table in oracle?
How to use regular expression in pattern match conditions in oracle?
Does oracle database need java?
What happens if you use a wrong connect identifier?
How to convert a date to char in oracle? Give one example.
What is a procedure in oracle?
What is bind variable in oracle 11g?
What are the original export and import utilities?
What privilege is needed for a user to create indexes in oracle?
What is the difference between hot backup and cold backup in oracle?
How to define and use table alias names in oracle?