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
Can I create users through internet explorer in oracle 10g?
Explain the types of exception?
What is the disadvantage of User defind function?
What is the maximum number of triggers that can be applied to a single table?
What is a table index in oracle?
What are the system predefined user roles?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How to define an oracle sub procedure?
please explain.. DB architecture ...
What is the recommended interval at which to run statspack snapshots, and why?
How to create a new table in oracle?
What is an oracle recycle bin?
How to generate query output in html format?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is the database name in oracle?