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
Explain the blob datatype?
Whether any commands are used for months calculation? If so, what are they?
Where are the settings stored for each instance in oracle?
How to insert a new row into a table in oracle?
What is BBED in Oracle?
How to use attributes of the implicit cursor in oracle?
How to shutdown your 10g xe server from command line?
How do I limit the number of rows returned by an oracle query after ordering?
How to convert raw data type into text in oracle? Explain
Why packages are used in oracle?
What are the oracle built-in data types?
Is a rollback possible to any savepoint?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How to create a new view in oracle?
can u plz provide me oca sql dumps please i need them